{"text_format":"1","workbook":"xlsx","n_sheets":42,"sheets":["Introduction","60 Deg Inch Thread Data","55 Deg Whitworth Thread","60 Deg ISO Metric Thread","Trap Metric Thds","60 Deg from outside","3-Wire Meas","Cutting Speeds","Logan","Sherline","Spur Gears","Grinding","Metric Plain Chart","Metric QC Chart","Metric Ratio Table","English Ratio Table","Dividing Head","Knurling","Cyl. Square","Sine Bar","Find Nominal","Bolt Torque from Tensile","Gage Blocks","SFPM","Thd Length","Sheet1","Balancing I","Balancing II","Vibration I","Vibration II","Taper Measurement","Beam Deflection","Bungee","Compression- Round Wire","Compression- Rectangular Wire","Extension","Torsion","Wave Washers","Flats","Drop Tests","TT Counterweights","Barometric Pressure"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":2,"comments":11,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"60 Deg Inch Thread Data","index":1,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Basic Dimensions for 60 Degree Unified Threads"]
["Does not take into account thread classes- use published tables for standard threads!"]
["Warning- Initial thread data is used throughout worksheet page- enter accurate numbers!",null,null,null,null,null,null,null,null,null,"Converter:",16,"mm",{"$f":"L3/25.4","v":0.62992125984251968},"in"]
[null,null,null,null,null,null,null,null,null,null,null,1,"mm",{"$f":"1/(L4/25.4)","v":25.4},"tpi"]
["Nominal Size",null,1.5354300000000001,"in",25.4,"tpi",60,"deg","any ang?"]
["Pitch",null,null,null,{"$f":"1/E5","v":3.937007874015748E-2},"in ",{"$f":"E6*25.4","v":0.99999999999999989},"mm"]
["Height of sharp V",null,null,null,{"$f":"E6/(2*TAN(RADIANS(G5/2)))","v":3.4095488337970027E-2},"in ",{"$f":"E7*25.4","v":0.8660254037844386},"mm"]
[]
["male thread- maximum material condition"]
["Basic major diameter",null,{"$f":"C5","v":1.5354300000000001},"in",null,null,{"$f":"C10*25.4","v":38.999921999999998},"mm"]
["Minor diameter",null,{"$f":"C10-(2*0.625*E7)","v":1.4928106395775376},"in",null,null,{"$f":"C11*25.4","v":37.917390245269452},"mm"]
["Pitch diameter",null,{"$f":"C10-(2*0.375*E7)","v":1.5098583837465225},"in",null,null,{"$f":"C12*25.4","v":38.350402947161669},"mm"]
["Lead angle",null,{"$f":"DEGREES(ATAN(E6/(PI()*C12)))","v":0.47554635326832656},"degrees"]
["Width of top flat",null,{"$f":"0.125*E6","v":4.921259842519685E-3},"in",null,null,{"$f":"C14*25.4","v":0.12499999999999999},"mm"]
["Plunge depth",null,{"$f":"0.875*E7","v":2.9833552295723775E-2},"in",null,null,{"$f":"C15*25.4","v":0.7577722283113838},"mm"]
["Thread depth",null,{"$f":"0.625*E7","v":2.1309680211231266E-2},"in",null,null,{"$f":"C16*25.4","v":0.5412658773652741},"mm"]
["30 deg SP Plunge",null,{"$f":"E6-(0.125*E6)","v":3.4448818897637797E-2},"in"]
["30 deg Trunc Plunge",null,{"$f":"0.625*E6","v":2.4606299212598423E-2},"in"]
[]
["single point cutting tool geometry (Machinery's 23, pg 1670)"]
["Nose flat width (60)",null,{"$f":"0.25*E6","v":9.8425196850393699E-3},"in","this is the absolute maximum!"]
["t",null,{"$f":"DEGREES(ATAN(E6/(PI()*C11)))","v":0.48097679008734429},"deg","helix angle of thread at minor diameter"]
["t prime",null,{"$f":"DEGREES(ATAN(E6/(PI()*C10)))","v":0.4676267839836265},"deg","helix angle of thread at major diameter"]
["eff. relief angle",null,7,"deg","relief- choose wisely"]
["a",null,{"$f":"C24+C22","v":7.4809767900873441},"deg"]
["a prime",null,{"$f":"C24-C23","v":6.5323732160163734},"deg"]
["b",null,{"$f":"DEGREES(ATAN(TAN(RADIANS(C25))*COS(RADIANS(0.5*G5))))","v":6.4879120829339287},"deg"]
["b prime",null,{"$f":"DEGREES(ATAN(TAN(RADIANS(C26))*COS(RADIANS(0.5*G5))))","v":5.6633251192846883},"deg"]
["n ",null,{"$f":"DEGREES(ATAN((TAN(RADIANS(C25))-TAN(RADIANS(C26)))/(2*TAN(RADIANS(0.5*G5)))))","v":0.83388488876563882},"deg"]
[]
["female thread (nut)"]
["The pitch diameter of the nut must be equal to or larger than the pitch diameter of the male thread, depending on class."]
["The minor diameter of the nut must be equal to or larger than the minor diameter of the male thread."]
["For very small/fine threads, the minor diameter (drill size) should be determined by examination of the tap."]
[]
["Suggested minor diameter for normal fits",null,null,null,{"$f":"C11+(C5*H36)","v":1.4974169295775375},"in","based on",3.0000000000000001E-3,"in/in allowance"]
[]
["standard 3-wire method of measurement- no lead angle compensation"]
["Best wire size",null,{"$f":"0.57735/E5","v":2.2730314960629924E-2},"in"]
["Actual wire size",null,1.7999999999999999E-2,"in"]
["Measurement",null,0.63839999999999997,"in","Max. mtl.",{"$f":"C12+((3*C40)-(0.86603/E5))","v":1.529762714455184},"in"]
["Pitch diameter",null,{"$f":"C41-((3*C40)-(COS(RADIANS(G5/2))/E5))","v":0.61849548833796997},"in"]
["Difference",null,{"$f":"C42-C12","v":-0.89136289540855251},"in","PD exceeds maximum material condition if this is positive!"]
[]
["correction for top rake angle on tool"]
[]
["Rake angle",null,8,"deg"]
["New tool angle",null,{"$f":"DEGREES(2*ATAN(0.5/(0.5/(TAN(RADIANS(G5/2))*COS(RADIANS(C47))))))","v":59.515930597848545},"deg"]

{"sheet":"55 Deg Whitworth Thread","index":2,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Basic Dimensions for 55 Degree Whitworth (BSW) Threads"]
["Does not take into account thread classes- use published tables for standard threads!"]
["Warning- Initial thread data is used throughout worksheet page- enter accurate numbers!",null,null,null,null,null,null,null,null,null,"Converter:",16,"mm",{"$f":"L3/25.4","v":0.62992125984251968},"in"]
[null,null,null,null,null,null,null,null,null,null,null,1,"mm",{"$f":"1/(L4/25.4)","v":25.4},"tpi"]
["Nominal Size",null,1.5354000000000001,"in",26,"tpi",55,"deg"]
["Pitch (P)",null,null,null,{"$f":"1/E5","v":3.8461538461538464E-2},"in ",{"$f":"E6*25.4","v":0.97692307692307689},"mm"]
["Height of sharp V (H)",null,null,null,{"$f":"E6/(2*TAN(RADIANS(G5/2)))","v":3.6941963980214737E-2},"in ",{"$f":"E7*25.4","v":0.93832588509745429},"mm"]
[]
["male thread- maximum material condition"]
["Basic major diameter",null,{"$f":"C5","v":1.5354000000000001},"in",null,null,{"$f":"C10*25.4","v":38.999160000000003},"mm"]
["Minor diameter",null,{"$f":"C10-(2*C15)","v":1.4861440480263806},"in",null,null,{"$f":"C11*25.4","v":37.748058819870067},"mm"]
["Pitch diameter",null,{"$f":"C5-C15","v":1.5107720240131903},"in",null,null,{"$f":"C12*25.4","v":38.373609409935035},"mm"]
["Arc height (e)",null,{"$f":"(E7*SIN(RADIANS(G5/2)))/6","v":2.8429834396737877E-3},"in",null,null,{"$f":"C13*25.4","v":7.221177936771421E-2},"mm"]
["Radius (r) ",null,{"$f":"C13/(1-SIN(RADIANS(G5/2)))","v":5.2818878122374638E-3},"in",null,null,0.13415995043083156,"mm"]
["Height of thread",null,{"$f":"E6/(3*TAN(RADIANS(G5/2)))","v":2.4627975986809821E-2},"in",null,null,0.62555059006496938,"mm"]
["Height of straight flank",null,{"$f":"C15-(2*C13)","v":1.8942009107462247E-2},"in",null,null,0.48112703132954104,"mm"]
["Lead angle",null,{"$f":"DEGREES(ATAN(E6/(PI()*(C12))))","v":0.46429175501907455},"degrees"]
[]
["female thread (nut)"]
["The pitch diameter of the nut must be equal to or larger than the pitch diameter of the male thread, depending on class."]
["The minor diameter of the nut must be equal to or larger than the minor diameter of the male thread."]
["For very small/fine threads, the minor diameter (drill size) should be determined by examination of the tap."]
[]
["Suggested minor diameter for normal fits",null,null,null,{"$f":"C11+(C5*H24)","v":1.4907502480263806},"in","based on",3.0000000000000001E-3,"in/in allowance"]
[]
["standard 3-wire method of measurement- no lead angle compensation"]
["Best wire size",null,{"$f":"0.56369*E6","v":2.1680384615384619E-2},"in","This is only for 55 degree threads."]
["Actual wire size",null,0.56369000000000002,"in"]
["Measurement",null,10.18364,"in","Max. matl.",{"$f":"C5-(1.60082/E5)+(3.16568*C28)","v":3.2582921592000003},"in"]
["Pitch diameter",null,{"$f":"C29-(3.16568*C28-0.96049)/E5","v":10.151948763107693},"in"]
["Difference",null,{"$f":"C30-C12","v":8.6411767390945027},"in","PD exceeds maximum material condition if this is positive!"]
[]
["correction for top rake angle on tool"]
[]
["Rake angle",null,0,"deg"]
["New tool angle",null,{"$f":"DEGREES(2*ATAN(0.5/(0.5/(TAN(RADIANS(G5/2))*COS(RADIANS(C35))))))","v":54.999999999999993},"deg"]

{"sheet":"60 Deg ISO Metric Thread","index":3,"n_rows":100,"n_cols":24,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Basic Dimensions for 60 Degree ISO Metric Threads"]
[]
["Warning- Initial thread data is used throughout spreadsheet- enter accurate numbers!",null,null,null,null,null,null,null,null,null,"Reverse Calculator using PD (MMC)"]
[]
["Nominal Size",null,12,"mm",null,"angle",60,"deg",null,null,"Pitch diameter",null,2.1976200000000001,"mm"]
["Pitch",null,0.5,"mm",null,null,null,null,null,null,"Pitch",null,0.25,"mm"]
["Height of sharp V",null,{"$f":"(SQRT(3)/2)*C6","v":0.4330127018922193},"mm"]
[null,null,null,null,null,null,null,null,null,null,"Height of sharp V",null,{"$f":"(SQRT(3)/2)*M6","v":0.21650635094610965}]
["male thread- maximum material condition",null,null,null,null,null,null,null,null,null,"Basic major diameter",null,{"$f":"M5 + 0.75 * M8","v":2.3599997632095824},"mm"]
["Basic major diameter",null,{"$f":"C5","v":12},"mm",null,null,null,null,null,null,"Minor diameter",null,{"$f":"M5 - M8/2","v":2.0893668245269454},"mm"]
["Pitch diameter",null,{"$f":"C10-(2*0.375*C7)","v":11.675240473580835},"mm"]
["Minor diameter",null,{"$f":"C10-(2*0.625*C7)","v":11.458734122634725},"mm"]
["Lead angle",null,{"$f":"DEGREES(ATAN(C6/(PI()*(C11))))","v":0.78099819574196705},"degrees"]
["Width of top flat",null,{"$f":"C6/8","v":6.25E-2},"mm"]
["Width of root",null,{"$f":"C6/4","v":0.125},"mm"]
["Plunge depth",null,{"$f":"0.875*C7","v":0.3788861141556919},"mm"]
["Thread depth",null,{"$f":"0.625*C7","v":0.27063293868263705},"mm"]
["30 deg SP Plunge",null,{"$f":"C6-(0.125*C6)","v":0.4375},"mm"]
["30 deg Trunc Plunge",null,{"$f":"0.625*C6","v":0.3125},"mm"]
[]
["single point cutting tool geometry (Machinery's 23, pg 1670)"]
["Nose flat width (60)",null,{"$f":"0.25*C6","v":0.125},"mm","this is the absolute maximum!"]
["t",null,{"$f":"DEGREES(ATAN(C6/(PI()*C12)))","v":0.79575283844446121},"deg","helix angle of thread at minor diameter"]
["t prime",null,{"$f":"DEGREES(ATAN(C6/(PI()*C10)))","v":0.75986432480499311},"deg","helix angle of thread at major diameter"]
["eff. relief angle",null,7,"deg","relief- choose wisely"]
["a",null,{"$f":"C25+C23","v":7.7957528384444608},"deg"]
["a prime",null,{"$f":"C25-C24","v":6.240135675195007},"deg"]
["b",null,{"$f":"DEGREES(ATAN(TAN(RADIANS(C26))*COS(RADIANS(0.5*G5))))","v":6.761725723819926},"deg"]
["b prime",null,{"$f":"DEGREES(ATAN(TAN(RADIANS(C27))*COS(RADIANS(0.5*G5))))","v":5.4094546131510235},"deg"]
["n ",null,{"$f":"DEGREES(ATAN((TAN(RADIANS(C26))-TAN(RADIANS(C27)))/(2*TAN(RADIANS(0.5*G5)))))","v":1.3674479517828653},"deg"]
[]
["female thread (nut)"]
["The pitch diameter of the nut must be equal to or larger than the pitch diameter of the male thread, depending on class."]
["The minor diameter of the nut must be equal to or larger than the minor diameter of the male thread."]
["For very small/fine threads, the minor diameter (drill size) should be determined by examination of the tap."]
[]
["Suggested minor diameter for normal fits",null,null,null,{"$f":"C12+(C5*H37)","v":11.494734122634725},"mm","based on",3.0000000000000001E-3,"mm/mm allowance"]
[]
["Tap drill size",null,null,null,{"$f":"C5-C6","v":11.5},"mm","or",{"$f":"E39/25.4","v":0.45275590551181105},"in"]
[]
["Standard 3-wire method of measurement- no lead angle compensation"]
["Best wire size",null,{"$f":"0.57735*C6","v":0.28867500000000001},"mm"]
[]
[]
["Fundamental Deviations & Tolerances by Formulas"]
[]
[null,"Nut Thread, D2, D1",null,"Bolt Thread, d1, d2"]
[null,"G","H","e","g","h",null,"Diameter Ranges",null,null,null,"Bolt PD Tolerance Grades for Mean Diameter entered at left, um",null,null,null,null,null,null,null,"Nut PD Tolerance Grades"]
["pitch","EI","EI","es","es","es",null,"over","to & inc","mean",null,3,4,5,6,7,8,9,null,4,5,6,7,8]
[0.2,{"$f":"+(15 + 11*A50)","v":17.2},{"$f":"0","v":0},null,{"$f":"-(15 + 11*A50)","v":-17.2},{"$f":"0","v":0},null,0.99,1.4,{"$f":"SQRT(H50*I50)","v":1.1772850122209149},null,{"$f":"0.5*O50","v":31.159988442825458},{"$f":"0.63*O50","v":39.261585437960079},{"$f":"0.8*O50","v":49.855981508520735},{"$f":"90*A50^0.4*$J$60^0.1","v":62.319976885650917},{"$f":"1.25*O50","v":77.899971107063649},{"$f":"1.6*O50","v":99.711963017041469},{"$f":"2*O50","v":124.63995377130183},null,{"$f":"0.85*O50","v":52.971980352803278},{"$f":"1.06*O50","v":66.059175498789969},{"$f":"1.32*O50","v":82.262369489059211},{"$f":"1.7*O50","v":105.94396070560656},{"$f":"2.12*O50","v":132.11835099757994}]
[0.25,{"$f":"+(15 + 11*A51)","v":17.75},{"$f":"0","v":0},null,{"$f":"-(15 + 11*A51)","v":-17.75},{"$f":"0","v":0},null,1.4,2.8,{"$f":"SQRT(H51*I51)","v":1.9798989873223329},null,{"$f":"0.5*O51","v":34.069149587896227},{"$f":"0.63*O51","v":42.927128480749246},{"$f":"0.8*O51","v":54.510639340633965},{"$f":"90*A51^0.4*$J$60^0.1","v":68.138299175792454},{"$f":"1.25*O51","v":85.172873969740564},{"$f":"1.6*O51","v":109.02127868126793},{"$f":"2*O51","v":136.27659835158491},null,{"$f":"0.85*O51","v":57.917554299423585},{"$f":"1.06*O51","v":72.22659712634001},{"$f":"1.32*O51","v":89.942554912046049},{"$f":"1.7*O51","v":115.83510859884717},{"$f":"2.12*O51","v":144.45319425268002}]
[0.3,18.3,{"$f":"0","v":0},null,-18.3,{"$f":"0","v":0},null,2.8,5.6,3.9597979746446659,null,36.646608749718283,46.174727024645037,58.634573999549254,73.293217499436565,91.616521874295699,117.26914799909851,146.58643499887313,null,62.299234874521076,77.690810549402769,96.747047099256264,124.59846974904215,155.38162109880554]
[0.35,18.850000000000001,{"$f":"0","v":0},null,-18.850000000000001,{"$f":"0","v":0},null,5.6,11.2,7.9195959492893317,null,38.977367816230142,49.111483448449981,62.36378850596823,77.954735632460284,97.443419540575348,124.72757701193646,155.90947126492057,null,66.26152528759124,82.632019770407908,102.90025103484759,132.52305057518248,165.26403954081582]
[0.4,19.399999999999999,{"$f":"0","v":0},null,-19.399999999999999,{"$f":"0","v":0},null,11.2,22.4,15.839191898578663,null,41.115851249900153,51.805972574874197,65.785361999840248,82.231702499800306,102.78962812475038,131.5707239996805,164.46340499960061,null,69.896947124830263,87.165604649788335,108.54584729973641,139.79389424966053,174.33120929957667]
[0.45,19.95,{"$f":"0","v":0},null,-19.95,{"$f":"0","v":0},null,22.4,45,31.749015732775085,null,43.099307797212838,54.305127824488174,68.958892475540537,86.198615594425675,107.7482694930321,137.91778495108107,172.39723118885135,null,73.268823255261822,91.370532530091225,113.7821725846419,146.53764651052364,182.74106506018245]
[0.5,20.5,{"$f":"0","v":0},{"$f":"-(50 + 11*A56)","v":-55.5},-20.5,{"$f":"0","v":0},null,45,90,63.63961030678928,null,44.954512394534149,56.642685617113031,71.927219831254646,89.909024789068297,112.38628098633538,143.85443966250929,179.81804957813659,null,76.422671070708049,95.303566276412397,118.67991272157016,152.8453421414161,190.60713255282479]
[0.6,21.6,{"$f":"0","v":0},{"$f":"-(50 + 11*A57)","v":-56.6},-21.6,{"$f":"0","v":0},null,90,180,127.27922061357856,null,48.35549014825245,60.927917586798088,77.368784237203926,96.7109802965049,120.88872537063112,154.73756847440785,193.4219605930098,null,82.204333252029159,102.5136391142952,127.65849399138648,164.40866650405832,205.0272782285904]
[0.7,22.7,{"$f":"0","v":0},-57.7,-22.7,{"$f":"0","v":0},null,180,355,252.78449319529076,null,51.430945174620476,64.802990920021799,82.289512279392767,102.86189034924095,128.5773629365512,164.57902455878553,205.7237806984819,null,87.432606796854813,109.03360377019541,135.77769526099806,174.86521359370963,218.06720754039083]
[0.75,23.25,{"$f":"0","v":0},-58.25,-23.25,{"$f":"0","v":0},null,null,null,null,null,52.870058995037049,66.616274333746688,84.59209439205928,105.7401179900741,132.17514748759262,169.18418878411856,211.48023598014819,null,89.879100291562978,112.08452506947854,139.57695574689782,179.75820058312596,224.16905013895709]
[0.8,23.8,{"$f":"0","v":0},-58.8,-23.8,{"$f":"0","v":0},null,"Enter mean here:",null,15.839,null,54.252690982404843,68.358390637830098,86.804305571847749,108.50538196480969,135.6317274560121,173.6086111436955,217.01076392961937,null,92.229574670088226,115.01570488269827,143.2271041935488,184.45914934017645,230.03140976539655]
[1,26,{"$f":"0","v":0},-61,-26,{"$f":"0","v":0},null,null,null,null,null,59.317834729525941,74.740471759202691,94.908535567241515,118.63566945905188,148.29458682381485,189.81707113448303,237.27133891810377,null,100.8403190401941,125.753809626595,156.5990836859485,201.68063808038821,251.50761925319]
[1.25,28.75,{"$f":"0","v":0},-63.75,-28.75,{"$f":"0","v":0},null,null,null,null,null,64.855870801699098,81.718397210140864,103.76939328271857,129.7117416033982,162.13967700424774,207.53878656543714,259.42348320679639,null,110.25498036288846,137.4944460996021,171.21949891648563,220.50996072577692,274.9888921992042]
[1.5,31.5,{"$f":"0","v":0},-66.5,-31.5,{"$f":"0","v":0},null,null,null,null,null,69.762461086981006,87.900700969596073,111.61993773916961,139.52492217396201,174.40615271745253,223.23987547833923,279.04984434792402,null,118.59618384786771,147.89641750439975,184.17289726962986,237.19236769573541,295.7928350087995]
[1.75,34.25,{"$f":"0","v":0},-69.25,-34.25,{"$f":"0","v":0},null,null,null,null,null,74.199419764144025,93.491268902821474,118.71907162263045,148.39883952828805,185.49854941036006,237.4381432452609,296.7976790565761,null,126.13901359904484,157.30276989998535,195.88646817734025,252.27802719808969,314.6055397999707]
[2,37,{"$f":"0","v":0},-72,-37,{"$f":"0","v":0},null,null,null,null,null,78.2703521755286,98.620643741166035,125.23256348084577,156.5407043510572,195.67588043882151,250.46512696169154,313.0814087021144,null,133.05959869839862,165.93314661212065,206.63372974339552,266.11919739679723,331.8662932242413]
[2.5,42.5,{"$f":"0","v":0},-77.5,-42.5,{"$f":"0","v":0},null,null,null,null,null,85.577834582906732,107.82807157446248,136.92453533265078,171.15566916581346,213.94458645726684,273.84907066530155,342.31133833162693,null,145.48231879094143,181.42500931576228,225.92548329887379,290.96463758188287,362.85001863152456]
[3,48,{"$f":"0","v":0},-83,-48,{"$f":"0","v":0},null,null,null,null,null,92.052119279257653,115.98567029186464,147.28339084681224,184.10423855851531,230.13029819814415,294.56678169362448,368.20847711703061,null,156.48860277473801,195.15049287202623,243.0175948972402,312.97720554947603,390.30098574405247]
[3.5,53.5,{"$f":"0","v":0},-88.5,-53.5,{"$f":"0","v":0},null,null,null,null,null,97.906721353546686,123.36246890546883,156.6507541656747,195.81344270709337,244.76680338386672,313.3015083313494,391.62688541418675,null,166.44142630102937,207.56224926951899,258.47374437336327,332.88285260205873,415.12449853903797]
[4,59,{"$f":"0","v":0},-94,-59,{"$f":"0","v":0},null,null,null,null,null,103.27834887459039,130.1307195819839,165.24535819934465,206.55669774918078,258.19587218647598,330.4907163986893,413.11339549836157,null,175.57319308680366,218.95009961413163,272.65484102891867,351.14638617360731,437.90019922826326]
[4.5,64.5,{"$f":"0","v":0},-99.5,-64.5,{"$f":"0","v":0},null,null,null,null,null,108.26056646327399,136.40831374372522,173.2169063412384,216.52113292654798,270.65141615818499,346.4338126824768,433.04226585309596,null,184.04296298756577,229.51240090214085,285.80789546304334,368.08592597513154,459.02480180428171]
[5,70,{"$f":"0","v":0},-105,-70,{"$f":"0","v":0},null,null,null,null,null,112.92062971895959,142.27999344588909,180.67300755033534,225.84125943791918,282.30157429739899,361.34601510067068,451.68251887583835,null,191.96507052223129,239.39173500419435,298.11046245805335,383.93014104446257,478.78347000838869]
[5.5,75.5,{"$f":"0","v":0},-110.5,-75.5,{"$f":"0","v":0},null,null,null,null,null,117.30873874316407,147.80901081638672,187.69398198906254,234.61747748632814,293.27184685791019,375.38796397812507,469.23495497265628,null,199.42485586337892,248.69452613550783,309.69507028195318,398.84971172675785,497.38905227101566]
[6,81,{"$f":"0","v":0},-116,-81,{"$f":"0","v":0},null,null,null,null,null,121.46349959239051,153.04400948641205,194.34159934782483,242.92699918478101,303.65874898097627,388.68319869564965,485.85399836956202,null,206.48794930706384,257.50261913586786,320.66363892391092,412.97589861412769,515.00523827173572]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Bolt Major Diameter Tolerances, um",null,null,null,null,null,null,null,"Nut Minor Diameter Tolerances, um"]
[null,null,null,null,null,null,null,null,null,null,null,null,4,null,6,null,8,null,null,4,5,6,7,8]
[null,null,null,null,null,null,null,null,null,null,0.2,null,{"$f":"0.63*O77","v":34.344777569279167},null,{"$f":"180*POWER(K77^2, 1/3) - 3.15/SQRT(K77)","v":54.515519951236769},null,{"$f":"1.6*O77","v":87.224831921978833},null,null,{"$f":"0.63*V77","v":37.756395977280931},{"$f":"0.8*V77","v":47.944629812420231},{"$f":"433*K77 - 190*K77^1.22","v":59.930787265525282},{"$f":"1.25*V77","v":74.913484081906603},{"$f":"1.6*V77","v":95.889259624840463}]
[null,null,null,null,null,null,null,null,null,null,0.25,null,{"$f":"0.63*O78","v":41.033819823298458},null,{"$f":"180*POWER(K78^2, 1/3) - 3.15/SQRT(K78)","v":65.133047338568986},null,{"$f":"1.6*O78","v":104.21287574171038},null,null,{"$f":"0.63*V78","v":46.138746836281896},{"$f":"0.8*V78","v":58.588884871469077},{"$f":"433*K78 - 190*K78^1.22","v":73.236106089336346},{"$f":"1.25*V78","v":91.545132611670425},{"$f":"1.6*V78","v":117.17776974293815}]
[null,null,null,null,null,null,null,null,null,null,0.3,null,47.195945108061572,null,74.914198584224721,null,119.86271773475956,null,null,54.283163238673971,68.931000937998689,86.163751172498365,107.70468896562295,137.86200187599738]
[null,null,null,null,null,null,null,null,null,null,0.35,null,52.965034384087048,null,84.071483149344516,null,134.51437303895122,null,null,62.221483740324373,79.01140792422143,98.764259905276788,123.45532488159598,158.02281584844286]
[null,null,null,null,null,null,null,null,null,null,0.4,null,58.42522153607041,null,92.738446882651445,null,148.38151501224232,null,null,69.977214976391153,88.859955525576083,111.07494440697009,138.84368050871262,177.71991105115217]
[null,null,null,null,null,null,null,null,null,null,0.45,null,63.633580642050148,null,101.00568355880976,null,161.60909369409563,null,null,77.568509564848938,98.499694685522471,123.12461835690308,153.90577294612885,196.99938937104494]
[null,null,null,null,null,null,null,null,null,null,0.5,null,68.631016714509897,null,108.93812176906333,null,174.30099483050134,null,null,85.009858629200437,107.94902683073072,134.93628353841339,168.67035442301673,215.89805366146143]
[null,null,null,null,null,null,null,null,null,null,0.6,null,78.108361662318416,null,123.98152644812447,null,198.37044231699917,null,null,99.488241776028687,126.33427527114755,157.91784408893443,197.39730511116804,252.66855054229509]
[null,null,null,null,null,null,null,null,null,null,0.7,null,87.029625574389357,null,138.14226281649104,null,221.02762050638569,null,null,113.48653128760242,144.10988100013006,180.13735125016257,225.17168906270319,288.21976200026012]
[null,null,null,null,null,null,null,null,null,null,0.75,null,91.318134287749047,null,144.94941950436356,null,231.9190712069817,null,null,120.32329597792246,152.79148695609203,190.98935869511502,238.73669836889377,305.58297391218406]
[null,null,null,null,null,null,null,null,null,null,0.8,null,95.506419089172084,null,151.59749061773346,null,242.55598498837355,null,null,127.05948509886836,161.3453779033249,201.68172237915613,252.10215297394515,322.6907558066498]
[null,null,null,null,null,null,null,null,null,null,1,null,111.41549999999999,null,176.85,null,282.95999999999998,null,null,144.9,184,{"$f":"230*K88^0.7","v":230},287.5,368]
[null,null,null,null,null,null,null,null,null,null,1.25,null,129.81405267238296,null,206.05405186092534,null,329.68648297748058,null,null,169.3968751118723,215.10714299920292,{"$f":"230*K89^0.7","v":268.88392874900364},336.10491093625456,430.21428599840584]
[null,null,null,null,null,null,null,null,null,null,1.5,null,146.97569958679335,null,233.29476124887833,null,373.27161799820533,null,null,192.45635966778909,244.38902814957348,305.48628518696682,381.85785648370853,488.77805629914695]
[null,null,null,null,null,null,null,null,null,null,1.75,null,163.1789345531574,null,259.01418183040857,null,414.42269092865376,null,null,214.38530803263168,272.23531178746879,340.294139734336,425.36767466792003,544.47062357493758]
[null,null,null,null,null,null,null,null,null,null,2,null,178.6080258859291,null,283.50480299353825,null,453.60768478966122,null,null,235.39074446403706,298.90888185909466,373.63610232386833,467.0451279048354,597.81776371818933]
[null,null,null,null,null,null,null,null,null,null,2.5,null,207.62947796958909,null,329.5705999517287,null,527.31295992276591,null,null,275.18603548975244,349.44258474889199,436.80323093611497,546.0040386701437,698.88516949778398]
[null,null,null,null,null,null,null,null,null,null,3,null,234.73575392487913,null,372.59643480139545,null,596.15429568223271,null,null,312.64627866831853,397.01114751532515,496.26393439415642,620.32991799269553,794.0222950306503]
[null,null,null,null,null,null,null,null,null,null,3.5,null,260.35097789056351,null,413.25552046121192,null,661.20883273793913,null,null,348.26996038614953,442.24756874431688,552.80946093039609,691.01182616299513,884.49513748863376]
[null,null,null,null,null,null,null,null,null,null,4,null,284.75784411615717,null,451.99657796215428,null,723.19452473944693,null,null,382.39339254198472,485.57891116442511,606.97363895553133,758.71704869441419,971.15782232885022]
[null,null,null,null,null,null,null,null,null,null,4.5,null,308.15671056923719,null,489.13763582418602,null,782.62021731869766,null,null,415.25717499092985,527.31069840118084,659.138373001476,823.92296625184497,1054.6213968023617]
[null,null,null,null,null,null,null,null,null,null,5,null,330.69611613306932,null,524.91447005249097,null,839.8631520839856,null,null,447.04103354064694,567.67115370240879,709.58894212801101,886.98617766001371,1135.3423074048176]
[null,null,null,null,null,null,null,null,null,null,5.5,null,352.49004446054948,null,559.50800708023723,null,895.21281132837964,null,null,477.88375564716074,606.83651510750576,758.54564388438212,948.18205485547765,1213.6730302150115]
[null,null,null,null,null,null,null,null,null,null,6,null,373.62838129222507,null,593.06092268607154,null,948.89747629771455,null,null,507.89537812040226,644.94651189892352,806.18313987365434,1007.728924842068,1289.893023797847]

{"sheet":"Trap Metric Thds","index":4,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["30 Degree Trapezoidal Metric Threads",null,null,null,null,"(or any other angle)"]
[]
[null,"Included angle",null,null,30,"deg"]
[null,"Pitch",null,null,1,"mm",null,{"$f":"E4/25.4","v":3.937007874015748E-2},"in"]
[null,"Basic OD",null,null,5.5,"mm",null,{"$f":"E5/25.4","v":0.21653543307086615},"in"]
[null,"Clearance on crest",null,null,7.4999999999999997E-2,"mm",null,2.952755905511811E-3,"in"]
[]
[null,"Thread depth",null,null,{"$f":"(0.5*E4)+E6","v":0.57499999999999996},"mm",null,2.2637795275590549E-2,"in"]
[null,"Minor diameter",null,null,{"$f":"E5-(2*E8)","v":4.3499999999999996},"mm",null,0.17125984251968504,"in"]
[null,"Pitch diameter",null,null,{"$f":"E5-(0.5*E4)","v":5},"mm",null,0.19685039370078741,"in"]
[null,"Width of flat at crest",null,null,{"$f":"2*TAN(RADIANS(E3/2))*((0.25*E4)/TAN(RADIANS(E3/2))-0.25*E4)","v":0.36602540378443865},"mm",null,1.4410448967891286E-2,"in"]
[null,"Width of flat at root",null,null,{"$f":"2*TAN(RADIANS(E3/2))*((0.25*E4)/TAN(RADIANS(E3/2))-0.25*E4-E6)","v":0.32583302491977029},"mm",null,1.2828071847235051E-2,"in"]
[null,"Angled feed amount",null,null,{"$f":"E8/(COS(RADIANS(E3/2)))","v":0.5952838037357977},"mm",null,2.343637022581881E-2,"in"]

{"sheet":"60 Deg from outside","index":5,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Build-down of thread system from outer wall dimensions"]
[]
[null,"Outside dim of nut (min)",null,null,null,3.4,"mm"]
[null,"Minimum wall thickness",null,null,null,0.15,"mm"]
[null,"Max root of nut",null,null,null,{"$f":"F3-(2*F4)","v":3.1},"mm"]
[null,"Pitch",null,null,null,0.5,"mm"]
[null,"H",null,null,null,{"$f":"0.866025*F6","v":0.43301250000000002},"mm"]
[null,"Max PD of nut",null,null,null,{"$f":"F5-(0.6495*F6)","v":2.7752500000000002},"mm"]
[null,"Max crest of nut (not really)",null,null,null,{"$f":"F5-(1.0825*F6)","v":2.5587499999999999},"mm"]
[null,"PD tolerance range allotted to nut",null,null,null,0.01,"mm"]
[null,"PD tolerance range allotted to screw",null,null,null,2.5000000000000001E-2,"mm"]
[null,"Max PD of screw",null,null,null,{"$f":"F8-(F10+F11)","v":2.7402500000000001},"mm"]
[null,"Min PD of screw",null,null,null,{"$f":"F12-F11","v":2.7152500000000002},"mm"]

{"sheet":"3-Wire Meas","index":6,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["60 Degree Screw Threads- 3 Wire Method",null,null,null,null,"The Van Keuren Co. Catalog #36 (1955)"]
[]
[null,null,null,null,null,"metric"]
["TPI (n)",null,158.75]
["Pitch (p)",null,{"$f":"1/C4","v":6.2992125984251968E-3},null,null,{"$f":"25.4/C4","v":0.16}]
["Depth (h)",null,{"$f":"0.649519/C4","v":4.0914582677165348E-3},null,null,{"$f":"25.4*C6","v":0.10392303999999998}]
[]
["Best Wire Size (G)",null,{"$f":"0.57735/C4","v":3.6368503937007877E-3},null,null,{"$f":"25.4*C8","v":9.2376E-2}]
[]
["Actual Wire Size (G)",null,3.6310000000000001E-3,null,null,{"$f":"25.4*C10","v":9.2227400000000001E-2}]
[]
["Nominal Diameter (D)",null,null,4.3461078E-2,null,{"$f":"25.4*D12","v":1.1039113811999999}]
["Nominal Pitch Diameter (E)",null,null,{"$f":"D12-C6","v":3.9369619732283465E-2},null,{"$f":"25.4*D13","v":0.99998834119999991}]
[]
["Measurement over wires (M)",null,null,4.4816000000000002E-2]
[]
["Actual Pitch Diameter",null,null,{"$f":"D15-((3*C10)-(0.86603/C4))","v":3.9378307086614175E-2},null,"Based on pg. 151 and neglects effect of lead angle- results .00005\" to .00015\" larger than true size."]
[]
["Error in Pitch Diameter",null,null,{"$f":"D17-D13","v":8.6873543307108836E-6},null,{"$f":"25.4*D19","v":2.2065880000005642E-4},{"$f":"F19*1000","v":0.22065880000005642},"um"]
[]
["Buckingham Simplified Formula",null,null,null,null,"Machinery's Handbook 23, pg. 1631"]
[]
["Lead Angle",null,null,{"$f":"DEGREES(ATAN(C5/(PI()*D13)))","v":2.9155649736593845},null,"This is only true at the pitch diameter."]
["Best Wire Size (W)",null,null,{"$f":"(0.5*C5*COS(RADIANS(D23)))/(COS(RADIANS(30)))","v":3.6321444616709401E-3}]
["Actual Wire Size",null,null,3.6310000000000001E-3]
["Measurment over wires (M)",null,null,{"$f":"D13+(D25*(1+SIN(RADIANS(30))))","v":4.4816119732283465E-2},null,"Based on pg. 1631 and includes lead angle if and only if best wire size is used."]
[]
["Actual Wire Size",null,null,3.6310000000000001E-3]
["PD for new contact points",null,null,3.9378000000000003E-2,null,"Enter approximate PD for undersize wires here."]
["Lead Angle at new PD",null,null,{"$f":"DEGREES(ATAN(C5/(PI()*D29)))","v":2.9149455650569887},null,"Lead angle doesn't change  much since thread is so shallow."]
[]
["Dr. Werner F. Vogel Best Approximation Formula- #800 from The Van Keuren Co. Cat. #36"]
[]
[null,"# of starts",null,1,null,"lead angle, λ",null,{"$f":"DEGREES(ATAN(H37/(PI()*D35)))","v":2.9155310950358575}]
[null,"pitch dia",null,3.9370078000000003E-2,null,"axial pa, θx",null,30]
[null,"tpi",null,158.75,null,"norm pa, θn",null,{"$f":"DEGREES(ATAN(TAN(RADIANS(H35))*COS(RADIANS(H34))))","v":29.967875959560015}]
[null,"axial pitch",null,{"$f":"1/D36","v":6.2992125984251968E-3},null,"lead   ",null,{"$f":"D34*D37","v":6.2992125984251968E-3}]
[]
[null,"sigma",null,{"$f":"PI()/(2*D34)","v":1.5707963267948966},"rad"]
[null,"gamma",null,{"$f":"D39*SIN(RADIANS(H34))^2","v":4.0638258538243498E-3},"rad"]
[null,"Z",null,0]
[null,"tan thetaM",null,{"$f":"TAN(RADIANS(H35))/TAN(RADIANS(H34))","v":11.336245813342437}]
[null,"CKAMF",null,{"$f":"(1/D40)+D40*(SIN(RADIANS(H36))^2-(SIN(RADIANS(H34))^2/3))+D42*COS(RADIANS(H34))^2+D41","v":257.38146476202138}]
[null,"tan b800",null,{"$f":"1/D43","v":3.8852836622272485E-3}]
[null,"b800",null,{"$f":"DEGREES(ATAN(D44))","v":0.22260923593394707},"deg"]
[null,"D to wire ctrs",null,{"$f":"D35 * (D39-RADIANS(D45))/SIN(RADIANS(D45)) * TAN(RADIANS(H34))^2","v":4.1184273019617933E-2}]
[null,"best wire dia",null,{"$f":"D46*SIN(RADIANS(D45))/(SIN(RADIANS(H34))*COS(RADIANS(H36)))","v":3.6313836100096185E-3}]
[null,"meas over wires",null,{"$f":"D46+D47","v":4.4815656629627554E-2}]
[null,"backlash",null,2E-3]
[null,"ATF",null,{"$f":"(1/SIN(RADIANS(D45))) * (1/( TAN(RADIANS(H34)) + TAN(RADIANS(H35)) * (1/TAN(RADIANS(D45))) ))","v":1.7314704518232893}]
[null,"reduction",null,{"$f":"D50*D49","v":3.4629409036465789E-3}]
[null,"meas over wires",null,{"$f":"D48-D51","v":4.1352715725980975E-2}]

{"sheet":"Cutting Speeds","index":7,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Cutting Speeds"]
[]
[]
[null,"Lathe spindle speed",null,425,"RPM",null,null,"Material",null,null,"HSS","carbide","cast alloy"]
[null,"Work diameter",null,2.5,"in"]
[null,"Surface speed",null,{"$f":"(PI()*D5*D4)/12","v":278.16184953659626},"SFPM",null,null,"Steel, tough",null,null,"50-60",null,"100-120"]
[null,null,null,null,null,null,null,"Steel, mild",null,null,"100-125",null,"200-250"]
[null,null,null,null,null,null,null,"Steel, alloy",null,null,"65-120",null,"130-240"]
[null,null,null,null,null,null,null,"Steel, carbon",null,null,"70-130",null,"140-260"]
[null,null,null,null,null,null,null,"Steel, free cutting",null,null,"115-225",null,"230-450"]
[null,null,null,null,null,null,null,"Steel, leaded",null,null,300,null,600]
[null,null,null,null,null,null,null,"Steel, stainless",null,null,"75-130",null,"150-260"]
[null,null,null,null,null,null,null,"Cast iron",null,null,"60-80",null,"120-160"]
[null,null,null,null,null,null,null,"Bronzes",null,null,"80-150",null,"160-300"]
[null,null,null,null,null,null,null,"Brass",null,null,"600+",null,"1200+"]
[null,null,null,null,null,null,null,"Aluminum",null,null,"250-350",null,"500-700"]

{"sheet":"Logan","index":8,"n_rows":58,"n_cols":14,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Logan 11\" Lathe Changegears for Figures I, II and III",null,null,null,null,null,"change things in RED only, formulas in BLUE"]
[]
[null,"Leadscrew",null,8,"tpi",null,{"$f":"1/D4","v":0.125},"pitch"]
[null,"Screw Constant",null,8,"tpi",null,"Permanent tumbler gears are 1:1 so this equals the leadscrew."]
[]
[null,"Required Thread",null,36,"tpi",null,{"$f":"1/D7","v":2.7777777777777776E-2},"pitch",{"$f":"G7*25.4","v":0.70555555555555549},"mm metric"]
[]
[null,"Trial Factor",null,3,null,null,"Choose this for sensible stud gear size."]
[]
[null,"Transfer 1",null,18,"teeth",null,"For no transfer gears, \"figure I\", enter same value for each.",null,null,null,null,null,null,"figures refer to the chart on the lathe"]
[null,"Transfer 2",null,54,"teeth",null,"18/54 combination is normal for \"figure II\"."]
[null,"Transfer Ratio A",null,{"$f":"D11/D12","v":0.33333333333333331}]
[]
[null,"Transfer 3",null,1,"teeth",null,"This is for \"figure III\" where the transfers are doubled and"]
[null,"Transfer 4",null,1,"teeth",null,"reversed- use 18/54 here and 24/48 above. For no transfer"]
[null,"Transfer Ratio B",null,{"$f":"D15/D16","v":1},null,null,"gears, enter the same value for each, say 1 and 1."]
[]
[null,"Stud Gear",null,{"$f":"D9*D5","v":24},"teeth",null,"Actual stud gear",null,null,24]
[null,"Leadscrew Gear",null,{"$f":"D9*D7*D13*D17","v":36},"teeth",null,"Actual leadscrew gear",null,null,36]
[]
[null,"Available gears",null,16,"48 (2)",37,"Actual tpi for odd threads",null,null,{"$f":"(1/(D13*D17*(J19/J20)))*D5","v":36}]
[null,null,null,18,52,47,"% error",null,null,{"$f":"100*((J22/D7)-1)","v":0},"%"]
[null,null,null,"24 (2)",54,100]
[null,null,null,"32 (2)",56,null,"Pitch",null,null,{"$f":"1/J22","v":2.7777777777777776E-2},"inches"]
[null,null,null,36,60,null,"Pitch",null,null,{"$f":"J25*25.4","v":0.70555555555555549},"mm"]
[null,null,null,40,64]
[null,null,null,44,"68 (diy)"]
[null,null,null,46,72]
[]
[null,"Threading Dial"]
[]
[null,null,"If TPI is divisible by 8 thread dial isn't needed- engage anywhere!"]
[null,null,"If TPI is even use any mark on the thread dial"]
[null,null,"If TPI is odd use only the numbers"]
[null,null,"If TPI is a 1/2 TPI like 11.5 use only the same number"]
[null,null,"If TPI is a 1/4 TPI or metric keep half nuts engaged and reverse spindle"]
[]
[null,"Metric Threading"]
[null,null,"use 37/47 for approximate or 100/127 for exact."]
[null,null,"can also use 63/40 and a factor of two elsewhere but a 40:1 dividing head won't do 63."]
[]
[null,"Gear Design for Logan"]
[]
[null,"DP",null,16,null,"Logan is typically 16"]
[null,"pressure angle",null,14.5,"deg","Logan and most older gears are 14.5 degree pressure angle. (this is used for the measurement across teeth below)"]
[null,"N",null,18,"teeth"]
[null,"OD of blank",null,{"$f":"(D47+2)/D45","v":1.25},"in"]
[null,"tooth thickness on pl",null,{"$f":"1.5708/D45","v":9.8174999999999998E-2},"in"]
[null,"pitch diameter",null,{"$f":"D47/D45","v":1.125},"in"]
[null,"pitch radius",null,{"$f":"D50/2","v":0.5625},"in"]
[null,"min total depth",null,{"$f":"2.157/D45","v":0.1348125},"in"]
[]
[null,"Measurement across several teeth:"]
[]
[null,"spaces",null,4]
[null,"factor",null,1.1089999999999999E-2,null,"use 0.01109 for 14.5, 0.0298 for 20, 0.04303 for 22.5 pressure angles"]
[null,"result",null,{"$f":"D51*COS(RADIANS(D46))*((D49/D51)+((2*PI()*D56)/D47)+D57)","v":0.86146869924379355},"in"]

{"sheet":"Sherline","index":9,"n_rows":57,"n_cols":15,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Sherline Metric Lathe Change Gears",null,null,null,null,"change only numbers in red, results from formulas are in blue, reference data in purple."]
[]
["Leadscrew pitch",null,1,"mm",null,"Metric version lathe is 1mm",null,null,null,null,null,"Sherline gears:",null,"3rd Party gears"]
[null,null,null,null,null,null,null,null,null,null,null,"56 pitch","24 pitch","56 pitch","24 pitch"]
["Required thread pitch",null,0.75,"mm",null,{"$f":"1/(C5/25.4)","v":33.86666666666666},"tpi",null,null,null,null,"A, B","C, D, E","A, B","C, D, E"]
[null,null,null,null,null,null,null,null,null,null,null,50,20,null,16]
["Ratio multiplier",null,100,null,null,"Scale factor- typically 50 or 100 for Sherline",null,null,null,null,null,100,22,null,25]
[null,null,null,null,null,null,null,null,null,null,null,127,24,null,60]
["\"C\" gear",null,24,"teeth",null,null,null,null,null,null,null,null,26]
["\"B\" gear",null,100,"teeth",null,"Usually 100 for Sherline",null,null,null,null,null,null,28]
["Transfer ratio",null,{"$f":"C9/C10","v":0.24},null,null,null,null,"inverse",{"$f":"1/C11","v":4.166666666666667},null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,32]
["\"A\" spindle gear",null,{"$f":"C7*(1/C3)","v":100},"teeth",null,"Actual spindle gear",null,null,100,"teeth",null,null,34]
["\"D\" leadscrew gear",null,{"$f":"C7*(1/C5)*C11","v":31.999999999999993},"teeth",null,"Actual leadscrew gear",null,null,32,"teeth",null,null,36]
[null,null,null,null,null,null,null,null,null,null,null,null,38]
["Note that the \"E\" gear can be anything convenient",null,null,null,null,"Actual pitch",null,null,{"$f":"1/(1/(C11*(I13/I14)))*(1/C3)","v":0.75},"mm",null,null,40]
["\"D\" cannot exceed 3\" in diameter if \"C\" is 20t",null,null,null,null,"% error",null,null,{"$f":"100*((I16/C5)-1)","v":0},"%"]
[]
[]
[null,null,null,null,null,null,null,null,"Ultra fine thread arrangement:"]
[null,null,null,null,null,null,null,null,"For ultra fine pitches the \"E\" gear is doubled up to provide reduction,"]
[null,null,null,null,null,null,null,null,"just like the C/B combination. Extra spacers and bushing will be needed."]
[null,null,null,null,null,null,null,null,"This routine calculates the pitch for various gears of your choosing."]
[]
[null,null,null,null,null,null,null,null,"A",50,"teeth",50,50,50,50]
[null,null,null,null,null,null,null,null,"B",100,"teeth",100,100,100,100]
[null,null,null,null,null,null,null,null,"C",24,"teeth",24,24,24,24]
[null,null,null,null,null,null,null,null,"D (outboard)",40,"teeth",60,60,60,40]
[null,null,null,null,null,null,null,null,"E1 (inboard)",40,"teeth",40,40,40,40]
[null,null,null,null,null,null,null,null,"E2 (outboard)",34,"teeth",20,24,32,34]
[]
[null,null,null,null,null,null,null,null,"Pitch",{"$f":"(J25/J28)*(J27/J26)*(J30/J29)*C3","v":0.255},"mm",0.1,0.12,0.16,0.255]
[null,null,null,null,null,null,null,null,"Leadscrew M",{"$f":"LCM(J32*100000,C3*100000)/100000","v":51},null,1,3,4,51]
[null,null,null,null,null,null,null,null,"# of threads",{"$f":"J33/J32","v":200},null,10,25,25,200]
[null,null,null,null,null,null,null,null,"threads/turn",{"$f":"C3/J32","v":3.9215686274509802},null,10,8.3332999999999995,6.25,3.9216000000000002]
[]
[null,null,null,null,null,null,null,null,"If you disengage the leadscrew, it may be turned by any multiple of"]
[null,null,null,null,null,null,null,null,"\"Leadscrew M\", then re-engaged, to pick up the thread and do multiple"]
[null,null,null,null,null,null,null,null,"cutting passes."]
[]
["Gear Design for Sherline"]
[]
["DP",null,60,null,59.27]
["pressure angle",null,20,"deg"]
["N",null,40,"teeth"]
["OD of blank",null,{"$f":"(C45+2)/C43","v":0.7},"in",{"$f":"C46*25.4","v":17.779999999999998},"mm"]
["tooth thickness on pl",null,{"$f":"1.5708/C43","v":2.6179999999999998E-2},"in",{"$f":"C47*25.4","v":0.6649719999999999},"mm"]
["pitch diameter",null,{"$f":"C45/C43","v":0.66666666666666663},"in",{"$f":"C48*25.4","v":16.93333333333333},"mm"]
["pitch radius",null,{"$f":"C48/2","v":0.33333333333333331},"in",{"$f":"C49*25.4","v":8.466666666666665},"mm"]
["min total depth",null,{"$f":"2.157/C43","v":3.5950000000000003E-2},"in",{"$f":"C50*25.4","v":0.91313},"mm"]
["english module",null,{"$f":"C48/C45","v":1.6666666666666666E-2}]
[]
["Measurement across several teeth:"]
[]
["spaces",null,2]
["factor",null,{"$f":"inv(RADIANS(C44))*2","v":2.9808767734672892E-2},null,"This factor is 2X INV(pressure angle) from above pressure angle"]
["result",null,{"$f":"C49*COS(RADIANS(C44))*((C47/C49)+((2*PI()*C55)/C45)+C56)","v":0.13234256030695776},"in","(got .2396\" for plastic gear that shrunk a bit- better photo is .13424)"]

{"sheet":"Spur Gears","index":10,"n_rows":60,"n_cols":17,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["General Metric Module Spur Gear Design",null,null,null,null,null,"Note that this worksheet has a vba macro for calculating the involute function and its inverse (INV and IINV)."]
[]
[]
[]
[]
[]
[]
["Standard Metric Gear Module with PD Known",null,null,null,null,null,null,"Module Derived from Center to Center Distance"]
[null,null,null,null,null,null,null,"this only works for non-shifted standard gears"]
["N",null,10,"teeth",null,null,null,"c-c distance",null,11.185,"mm"]
["pitch diameter",null,5.2908200000000001,"mm",null,null,null,"N1",null,10,"teeth","PD",{"$f":"J13*J11","v":4.4740000000000002},"mm","OD",{"$f":"(J11+2)*J13","v":5.3688000000000002},"mm"]
["module",null,{"$f":"C11/C10","v":0.52908200000000005},"mm",{"$f":"25.4/C12","v":48.007681228996631},"DP",null,"N2",null,40,"teeth","PD",{"$f":"J13*J12","v":17.896000000000001},"mm","OD",{"$f":"(J12+2)*J13","v":18.790800000000001},"mm"]
[null,null,null,null,null,null,null,"module",null,{"$f":"(2*J10)/(J11+J12)","v":0.44740000000000002},"mm"]
["DP",null,48,null,{"$f":"25.4/C14","v":0.52916666666666667},"module",null,"DP  ",null,{"$f":"25.4/J13","v":56.772463120250329}]
[]
["Standard Metric Gear Design with Module Known",null,null,null,null,null,null,"Standard Metric Gear Module with OD Known (risky business!)"]
[]
["N",null,10,"teeth",null,null,null,"N",10,"teeth"]
["module",null,0.52908200000000005,"mm",{"$f":"25.4/C19","v":48.007681228996631},"DP",null,"OD",6.35,"mm"]
["pressure angle",null,20,"deg",null,null,null,"module",{"$f":"I19/(I18+2)","v":0.52916666666666667},"mm",{"$f":"25.4/I20","v":48},"DP"]
["OD",null,{"$f":"(C18+2)*C19","v":6.3489840000000006},"mm"]
["pitch diameter",null,{"$f":"C19*C18","v":5.2908200000000001},"mm"]
["root diameter",null,{"$f":"C22-(2.5*C19)","v":3.9681150000000001},"mm"]
["circular pitch",null,{"$f":"PI()*C19","v":1.6621601243465951},"mm",null,null,null,"Center to Center Distance for Two Standard Gears"]
["base diameter",null,{"$f":"C22*(COS(RADIANS(C20)))","v":4.9717445119065005},"mm"]
["addendum",null,{"$f":"C19","v":0.52908200000000005},"mm",null,null,null,"N1, N2",null,10,"teeth",null,40,"teeth"]
["dedendum",null,{"$f":"1.157*C19","v":0.61214787400000004},"mm",null,null,null,"module",null,null,null,0.5,"mm"]
["working depth",null,{"$f":"2*C19","v":1.0581640000000001},"mm","`",null,null,"c-c distance",null,null,null,{"$f":"((J26*L27)+(M26*L27))/2","v":12.5},"mm"]
["total tooth depth",null,{"$f":"2.157*C19","v":1.1412298740000002},"mm"]
["tooth width at PD",null,{"$f":"1.5708*C19","v":0.83108200560000012},"mm"]
[]
["Profile Shifted Spur Gears",null,null,null,null,null,null,null,null,"Inverse Formulas for Routine at Left"]
["enter shift coefficients from right, or zero",null,null,null,null,null,null,null,null,"use this to determine shift coefficients"]
[null,null,"pinion",null,"gear",null,null,null,null,null,null,"pinion",null,"gear"]
["module",null,null,0.43049999999999999,null,null,null,{"$f":"25.4/D35","v":59.001161440185825},"DP","c-c distance",null,null,11.185,null,"mm"]
["N1, N2",null,10,null,40,"teeth",null,null,null,"c-c mod coefficient",null,null,{"$f":"(M35/D35)-((C36+E36)/2)","v":0.98141695702671328}]
["pressure angle",null,null,15,null,"deg",null,null,null,"working press angle",null,null,{"$f":"ACOS(COS(RADIANS(D37)) / (((2*M36)/(C36+E36))+1))","v":0.37790646940385053},null,"rad",{"$f":"DEGREES(M37)","v":21.652445747530411},"deg"]
["shift coefficients",null,0,null,0,null,null,null,null,"sum of shift coefficients",null,null,{"$f":"((C36+E36)*(inv(M37)-inv(RADIANS(D37)))) / (2*TAN(RADIANS(D37)))","v":1.206474936786823}]
["involute a working",null,null,{"$f":"2*TAN(RADIANS(D37)) * ((C38+E38) / (C36+E36)) +inv(RADIANS(D37))","v":6.149804631973288E-3},null,null,null,null,null,"shift coefficients",null,0.6,null,{"$f":"M38-L39","v":0.60647493678682307}]
["working press angle",null,null,{"$f":"IINV(D39)","v":0.26179938779915013},null,"rad",null,{"$f":"DEGREES(D40)","v":15.000000000000041},"deg"]
["c-c mod coefficient",null,null,{"$f":"(C36+E36)/2 * ((COS(RADIANS(D37))/COS(D40))-1)","v":5.5511151231257827E-15}]
["c-c distance calc",null,null,{"$f":"(((C36+E36)/2)+D41)*D35","v":10.762500000000003},null,"mm"]
["reference dia",null,{"$f":"C36*D35","v":4.3049999999999997},null,{"$f":"E36*D35","v":17.22},"mm"]
["base dia",null,{"$f":"C43*COS(RADIANS(D37))","v":4.1583106821744389},null,{"$f":"E43*COS(RADIANS(D37))","v":16.633242728697756},"mm"]
["working pitch dia",null,{"$f":"C44/COS(D40)","v":4.3050000000000006},null,{"$f":"E44/COS(D40)","v":17.220000000000002},"mm"]
["addendum",null,{"$f":"(1+D41-E38)*D35","v":0.43050000000000238},null,{"$f":"(1+D41-C38)*D35","v":0.43050000000000238},"mm"]
["tooth depth",null,null,{"$f":"ABS(2.25+D41-(C38+E38))*D35","v":0.96862500000000229},null,"mm"]
["tip dia",null,{"$f":"C43+2*C46","v":5.1660000000000048},null,{"$f":"E43+2*E46","v":18.081000000000003},"mm"]
["root dia",null,{"$f":"C48-2*D47","v":3.2287500000000002},null,{"$f":"E48-2*D47","v":16.143749999999997},"mm"]
[]
["Measurement Over N Spaces"]
["may only be good for non-shifted gears"]
["module",null,null,0.43049999999999999,"mm",{"$f":"25.4/D53","v":59.001161440185825},"DP"]
["N",null,null,40,"teeth"]
["spaces",null,null,3]
["pressure angle",null,null,15,"deg"]
["pitch diameter",null,null,17.22]
["tooth width",null,null,{"$f":"1.5708*D53","v":0.67622939999999998},"mm"]
["factor",null,null,{"$f":"inv(RADIANS(D56))*2","v":1.2299609263946576E-2}]
["result",null,null,{"$f":"(D57/2)*COS(RADIANS(D56))*((D58/(D57/2))+((2*PI()*D55)/D54)+D59)","v":4.6745941222725964},"mm",{"$f":"D60/25.4","v":0.18403913867214947},"in"]

{"sheet":"Grinding","index":11,"n_rows":52,"n_cols":26,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Grinding"]
[]
[null,"Surface Grinding"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"coefficiencts for main mesh list"]
[null,"wheel diameter",null,null,{"$f":"H5*0.0254","v":0.17779999999999999},"m ",null,7,"in",null,null,null,null,null,null,null,null,null,null,null,null,null,"a",1.6041526779754899E-4]
[null,"depth of cut",null,null,{"$f":"H6*0.0254","v":2.5400000000000001E-5},"m",null,1E-3,"in",null,null,null,null,null,null,null,null,null,null,null,null,null,"b",1.2338610779995699E-4]
[null,"RPM",null,null,{"$f":"H7","v":3550},"rpm",null,3550,"rpm",null,null,null,null,null,null,null,null,null,null,null,null,null,"c",-1.1563650944097801]
[null,"wheel speed",null,null,{"$f":"E5*PI()*E7/60","v":33.049031116989021},"m/s",null,{"$f":"H5*PI()*(1/12)*H7","v":6505.7147868088632},"sfpm",null,null,null,null,null,null,null,null,null,null,null,null,null,"offset",-22.9241634605062]
[null,"work speed",null,null,{"$f":"H9*0.0254","v":0.24999949999999999},"m/s",null,9.8424999999999994,"in/s"]
[null,"work speed, vw",null,null,{"$f":"E9*60000","v":14999.97},"mm/min",null,null,null,null,null,"mesh","um","corner",null,"creep feed grinding",null,null,null,null,null,null,"coefficients for micro mesh list"]
[null,"interface speed, high",null,null,{"$f":"E8+E9","v":33.299030616989022},"m/s",null,null,null,null,null,null,null,"in",null,"in","mm",null,null,null,null,null,"a",-1.5833989572238302E-2]
[null,"interface speed, low",null,null,{"$f":"E8-E9","v":32.799031616989019},"m/s",null,null,null,null,null,"F4",4750,{"$f":"(3*M12)/25400","v":0.5610236220472441},null,null,null,null,null,null,null,null,"b",4.3592726063189401E-4]
[null,"aggressiveness factor (20-30)",null,null,{"$f":"16.7*((E9*60000)/E8)*SQRT(E6/E5)","v":90.593932018425207},null,null,null,null,null,null,"F5",4000,0.47244094488188976,null,null,null,null,null,null,null,null,"c",-1.5915046967855999]
[null,"average chip thickness, hm",null,null,{"$f":"(E6*E10)/(E8*60*1000)","v":1.9213838001852215E-7},null,null,null,null,null,null,"F6",3350,0.3956692913385827,null,null,null,null,null,null,null,null,"offset",0.124486414912917]
[null,"removal rate, qw",null,null,{"$f":"(E6*E10)/60","v":6.3499873000000002E-3},"mm³/s/mm",null,null,null,null,null,"F7",2800,0.33070866141732286]
[null,"speed ratio of grinding, qs",null,null,{"$f":"(E8*60*1000)/(E10)","v":132.1963888607338},null,null,null,null,null,null,"F8",2360,0.27874015748031494]
[null,null,null,null,null,null,null,null,null,null,null,"F10",2000,0.23622047244094488]
[null,"infeed (my numbers)",null,null,null,null,null,null,null,null,null,"F12",1700,0.20078740157480315]
[null,null,null,null,null,null,null,null,null,null,null,"F14",1400,0.16535433070866143]
[null,"wheel width",null,null,null,null,null,0.5,"in",null,null,"F16",1180,0.13937007874015747]
[null,"extreme roughing",null,null,null,null,null,{"$f":"0.4*$H$20","v":0.2},"in",null,null,"F20",1000,0.11811023622047244]
[null,"roughing",null,null,null,null,null,{"$f":"0.2*$H$20","v":0.1},"in",null,null,"F22",850,0.10039370078740158]
[null,"typical",null,null,null,null,null,{"$f":"0.1*$H$20","v":0.05},"in",null,null,"F24",710,8.3858267716535428E-2]
[null,"fine finishing",null,null,null,null,null,{"$f":"0.05*$H$20","v":2.5000000000000001E-2},"in",null,"é","F30",600,7.0866141732283464E-2]
[null,"very fine finishing",null,null,null,null,null,{"$f":"0.025*$H$20","v":1.2500000000000001E-2},"in",null,"coarser","F36",500,5.905511811023622E-2,null,null,null,null,null,"Radiac Catalog, Pacific Catalog"]
[null,null,null,null,null,null,null,null,null,null,null,"F40",425,5.0196850393700788E-2,null,null,null,null,null,null,null,"particle","min radius","max radius","min finish","max finish"]
[null,null,null,null,null,null,null,null,null,null,"typical","F46",355,4.1929133858267714E-2,null,{"$f":"Q27/25.4","v":7.874015748031496E-2},2,null,null,null,null,"in"]
[null,null,null,null,null,null,null,null,null,null,null,"F54",300,3.5433070866141732E-2,null,null,null,null,null,"typical","46",0.02,0.02,"none","32","none"]
[null,null,null,null,null,null,null,null,null,null,"finer","F60",250,2.952755905511811E-2,null,{"$f":"Q29/25.4","v":3.937007874015748E-2},1,null,null,null,"54",1.7000000000000001E-2,".017",".02","20","32"]
[null,null,null,null,null,null,null,null,null,null,"ê","F70",212,2.5039370078740159E-2,null,null,null,null,null,"finer","60",1.6E-2,".016",".020","15","20"]
[null,null,null,null,null,null,null,null,null,null,null,"F80",180,2.1259842519685039E-2,null,{"$f":"Q31/25.4","v":2.3622047244094488E-2},0.6,null,null,"ê","70"]
[null,null,null,null,null,null,null,null,null,null,null,"F90",150,1.7716535433070866E-2,null,null,null,null,null,null,"80",1.0500000000000001E-2,".010",".020","12","18"]
[null,null,null,null,null,null,null,null,null,null,null,"F100",125,1.4763779527559055E-2,null,{"$f":"Q33/25.4","v":1.5748031496062995E-2},0.4,null,null,null,"90"]
[null,null,null,null,null,null,null,null,null,null,null,"F120",106,1.2519685039370079E-2,null,1.1811023622047244E-2,0.3,null,null,null,"100",8.5000000000000006E-3,".008",".010","10","15"]
[null,null,null,null,null,null,null,null,null,null,null,"F150",75,8.8582677165354329E-3,null,null,null,null,null,null,"120",5.5999999999999999E-3,".005",".008","8","12"]
[null,null,null,null,null,null,null,null,null,null,null,"F180",63,7.440944881889764E-3,null,null,null,null,null,null,"150",4.7999999999999996E-3,".004",".006","6","10"]
[null,null,null,null,null,null,null,null,null,null,null,"F220",53,6.2598425196850396E-3,null,null,null,null,null,null,"180"]
[null,"dressing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"220",2.5999999999999999E-3,".003",".005","5","6"]
[null,null,null,null,"rough","finish",null,null,null,null,null,"micro series starts here"]
[null,"diamond infeed, mm/pass",null,null,2.5000000000000001E-2,".012 to .020",null,null,null,null,null,"F230",53,{"$f":"(3*M40)/25400","v":6.2598425196850396E-3}]
[null,"traverse rate, mm/wheel rev",null,null,0.18,0.1,null,null,null,null,null,"F240",44.5,5.2559055118110232E-3]
[null,null,null,null,null,null,null,null,null,null,null,"F280",36.5,4.3110236220472442E-3]
[null,null,null,null,null,null,null,null,null,null,null,"F320",29.2,3.448818897637795E-3]
[null,"rules",null,null,null,null,null,null,null,null,null,"F360",22.8,2.6929133858267719E-3]
[null,null,null,"up","down",null,null,null,null,null,null,"F400",17.3,2.0433070866141736E-3]
[null,"wheel speed",null,"harder","softer",null,null,null,null,null,null,"F500",12.8,1.5118110236220475E-3]
[null,"work speed",null,"softer","harder",null,null,null,null,null,null,"F600",9.3000000000000007,1.0984251968503937E-3]
[null,"travers speed",null,"softer","harder",null,null,null,null,null,null,"F800",6.5,7.6771653543307081E-4]
[null,"infeed rate",null,"softer","harder",null,null,null,null,null,null,"F1000",4.5,5.3149606299212596E-4]
[null,null,null,null,null,null,null,null,null,null,null,"F1200",3,3.5433070866141734E-4]
[null,"Dry grinding with vitrious wheels requires 1-2 grades softer than wet grinding.",null,null,null,null,null,null,null,null,null,"F1500",2,2.3622047244094488E-4]
[null,null,null,null,null,null,null,null,null,null,null,"F2000",1.2,1.4173228346456691E-4]

{"sheet":"Metric Plain Chart","index":12,"n_rows":89,"n_cols":14,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["For Logan and Similar Plain Change Gear Lathes",null,null,null,null,null,"Lead Screw",8,"TPI",{"$f":"25.4/H1","v":3.1749999999999998},"mm pitch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,16,"standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,18,"standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,24,"standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,32,"standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,36,"standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,40,"standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,44,"standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,46,"standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,48,"standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,52,"standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,54,"standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,56,"standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,60,"standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,64,"standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,72,"standard"]
["mm Pitch",null,"Stud","Transpose1","Transpose2","Compound1","Compound2","Screw",null,"Calc.","Checked","Idler",28,"special"]
[null,null,null,"inboard","outboard","outboard","inboard",null,null,null,null,null,50,"special"]
[]
[0.2,null,16,47,37,60,18,60,null,{"$f":"(C22/H22)*(E22/D22)*(G22/F22)*$J$1","v":0.1999574468085106}]
[0.25,null,16,{"$f":"$D$22","v":47},{"$f":"$E$22","v":37},60,24,64,null,{"$f":"(C23/H23)*(E23/D23)*(G23/F23)*$J$1","v":0.2499468085106383}]
[0.3,null,18,{"$f":"$D$22","v":47},{"$f":"$E$22","v":37},40,16,60,null,0.29993617021276597]
[0.35,null,16,47,37,50,28,64,null,0.34992553191489362]
[0.4,null,16,47,37,40,24,60,null,0.39991489361702121]
[0.45,null,24,47,37,40,18,60,null,0.44990425531914896]
[0.5,null,24,47,37,64,32,60,null,0.4998936170212766,"good"]
[0.6,null,18,47,37,40,32,60,null,{"$f":"(C29/H29)*(E29/D29)*(G29/F29)*$J$1","v":0.59987234042553195}]
[0.65,null,18,47,37,60,52,60,null,0.64986170212765959]
[0.7,null,28,47,37,40,24,60,null,0.69985106382978723,"good"]
[0.75,null,18,47,37,1,1,60,null,0.74984042553191488,"good"]
[0.8,null,24,47,37,40,32,60,null,0.79982978723404252]
[0.9,null,18,47,37,60,48,40,null,0.89980851063829792]
[1,null,24,47,37,1,1,60,null,0.99978723404255321]
[1.2,null,48,47,37,40,24,60,null,1.1997446808510637]
[1.25,null,18,47,37,1,1,36,null,1.2497340425531915]
[1.3,null,24,47,37,40,52,60,null,1.2997234042553192]
[1.4,null,24,47,37,40,56,60,null,1.3997021276595745]
[1.5,null,36,47,37,1,1,60,null,1.4996808510638298]
[1.75,null,56,47,37,40,32,64,null,1.749627659574468]
[2,null,48,47,37,1,1,60,null,1.9995744680851064,"good"]
[2.25,null,36,47,37,1,1,40,null,2.2495212765957446]
[2.5,null,48,47,37,1,1,48,null,2.4994680851063831]
[2.75,null,44,47,37,1,1,40,null,2.7494148936170215]
[3,null,48,47,37,60,48,32,null,2.99936170212766]
[3.5,null,54,47,37,60,56,36,null,3.4992553191489364]
[4,null,48,47,37,60,48,24,null,3.9991489361702128]
[]
["These are the Logan factory recommendations using many single ratios but requiring 80 and 100 tooth screw gears"]
[]
[]
[]
[]
[]
["mm Pitch",null,"Stud","Transpose1","Transpose2","Compound1","Compound2","Screw",null,"Calc.","Notes"]
[null,null,null,"inboard","outboard","outboard","inboard"]
[]
[0.2,null,32,47,37,72,18,100,null,{"$f":"(C59/H59)*(E59/D59)*(G59/F59)*$J$1","v":0.19995744680851063}]
[0.25,null,40,47,37,72,18,100,null,{"$f":"(C60/H60)*(E60/D60)*(G60/F60)*$J$1","v":0.2499468085106383}]
[0.3,null,48,47,37,72,18,100,null,0.29993617021276592]
[0.35,null,56,47,37,72,18,100,null,0.34992553191489362]
[0.4,null,16,47,37,1,1,100,null,0.39991489361702126]
[0.45,null,18,47,37,1,1,100,null,0.4499042553191489]
[0.5,null,20,47,37,1,1,100,null,0.4998936170212766]
[0.6,null,24,47,37,1,1,100,null,0.59987234042553184]
[0.65,null,26,47,37,1,1,100,null,0.64986170212765959]
[0.7,null,28,47,37,1,1,100,null,0.69985106382978723]
[0.75,null,24,47,37,1,1,80,null,0.74984042553191488]
[0.8,null,30,47,37,1,1,100,null,0.74984042553191488]
[0.9,null,36,47,37,1,1,100,null,0.89980851063829781]
[1,null,40,47,37,1,1,100,null,0.99978723404255321]
[1.2,null,48,47,37,1,1,100,null,1.1997446808510637]
[1.25,null,40,47,37,1,1,80,null,1.2497340425531915]
[1.3,null,52,47,37,1,1,100,null,1.2997234042553192]
[1.4,null,56,47,37,1,1,100,null,1.3997021276595745]
[1.5,null,48,47,37,1,1,80,null,1.4996808510638298]
[1.75,null,56,47,37,1,1,80,null,1.749627659574468]
[2,null,32,47,37,1,1,40,null,1.9995744680851064,"Use 72 tooth idler gear"]
[2.25,null,36,47,37,1,1,40,null,2.2495212765957446,"Use 72 tooth idler gear"]
[2.5,null,32,47,37,1,1,32,null,2.4994680851063831,"Use 72 tooth idler gear"]
[2.75,null,44,47,37,1,1,40,null,2.7494148936170215,"Use 72 tooth idler gear"]
[3,null,48,47,37,1,1,40,null,2.9993617021276595,"Use 72 tooth idler gear"]
[3.5,null,28,47,37,1,1,20,null,3.4992553191489359,"Use 72 tooth idler gear"]
[4,null,32,47,37,1,1,20,null,3.9991489361702128,"Use 72 tooth idler gear"]
[4.5,null,36,47,37,1,1,20,null,4.4990425531914893,"Use 72 tooth idler gear"]
[5,null,40,47,37,1,1,20,null,4.9989361702127662,"Use 72 tooth idler gear"]
[5.5,null,44,47,37,1,1,20,null,5.498829787234043,"Use 72 tooth idler gear"]
[6,null,48,47,37,1,1,20,null,5.998723404255319,"Use 72 tooth idler gear"]

{"sheet":"Metric QC Chart","index":13,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["For Logan and Similar Lathes with a QC Gearbox",null,null,null,null,null,null,"Leadscrew",8,"TPI",{"$f":"25.4/I1","v":3.1749999999999998},"mm pitch"]
[null,null,null,null,null,null,null,"Transpose1",100]
[null,null,null,null,null,null,null,"Transpose2",127,null,{"$f":"K1*(I2/I3)","v":2.5},"mm virtual pitch"]
[]
[]
[]
[]
[]
[]
["mm Pitch","Stud ","Gearbox","QC TPI",null,null,"Ext. ratio","QC ratio","Product","TPI"]
[]
[]
[0.2,48,60,160,null,null,{"$f":"B13/C13","v":0.8},0.1,{"$f":"G13*H13","v":8.0000000000000016E-2},{"$f":"I13*$K$3","v":0.20000000000000004}]
[0.25,48,60,128,null,null,{"$f":"B14/C14","v":0.8},0.125,{"$f":"G14*H14","v":0.1},{"$f":"I14*$K$3","v":0.25}]
[0.3,72,60,160,null,null,1.2,0.1,0.12,0.3]
[0.35,42,60,80,null,null,0.7,0.2,0.13999999999999999,0.35]
[0.4,48,60,80,null,null,0.8,0.2,0.16000000000000003,0.40000000000000008]
[0.45,54,60,80,null,null,0.9,0.2,0.18000000000000002,0.45000000000000007]
[0.5,48,60,64,null,null,0.8,0.25,0.2,0.5]
[0.6,72,60,80,null,null,1.2,0.2,0.24,0.6]
[0.65,39,60,40,null,null,0.65,0.4,0.26,0.65]
[0.7,42,60,40,null,null,0.7,0.4,0.27999999999999997,0.7]
[0.75,72,60,64,null,null,1.2,0.25,0.3,0.75]
[0.8,48,60,40,null,null,0.8,0.4,0.32000000000000006,0.80000000000000016]
[0.9,54,60,40,null,null,0.9,0.4,0.36000000000000004,0.90000000000000013]
[1,48,60,32,null,null,0.8,0.5,0.4,1]
[1.2,72,60,40,null,null,1.2,0.4,0.48,1.2]
[1.25,60,60,32,null,null,1,0.5,0.5,1.25]
[1.3,39,60,20,null,null,0.65,0.8,0.52,1.3]
[1.4,42,60,20,null,null,0.7,0.8,0.55999999999999994,1.4]
[1.5,72,60,32,null,null,1.2,0.5,0.6,1.5]
[1.75,42,60,16,null,null,0.7,1,0.7,1.75]
[2,48,60,16,null,null,0.8,1,0.8,2]
[2.25,54,60,16,null,null,0.9,1,0.9,2.25]
[2.5,60,60,16,null,null,1,1,1,2.5]
[2.75,66,60,16,null,null,1.1000000000000001,1,1.1000000000000001,2.75]
[3,72,60,16,null,null,1.2,1,1.2,3]
[3.5,42,60,8,null,null,0.7,2,1.4,3.5]
[4,48,60,8,null,null,0.8,2,1.6,4]
[4.5,54,60,8,null,null,0.9,2,1.8,4.5]
[5,60,60,8,null,null,1,2,2,5]
[5.5,66,60,8,null,null,1.1000000000000001,2,2.2000000000000002,5.5]
[6,72,60,8,null,null,1.2,2,2.4,6]

{"sheet":"Metric Ratio Table","index":14,"n_rows":37,"n_cols":20,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Gear Selector for Fine Pitch Metric Threads on the Logan Changegear Lathe"]
[]
[null,"1) Enter the desired pitch. We assume that 37/47 or 100/127 gear packs are already installed."]
[null,"2) Select a gear pair from the table that produces the correct ratio. Install as the stud gear and leadscrew gear."]
[null,"3) If a simple ratio is impossible, select two gear pairs, one for each of the new 1st and 2nd ratios. Some fractional multiplier may be needed."]
[null,"4) Install one pair as the stud and outer of the pack nearest the leadscrew, the other pair as the inner of the pack, and the leadscrew gear."]
[null,"Warning- Especially with the finer threads, many combinations can't be physically installed and engage properly. Experimentation required!"]
[]
[null,null,null,null,null,null,null,null,null,null,"Logical",null,null,null,null,null,null,null,"Special","Alt."]
[null,"Enter desired pitch",null,null,null,0.35,"mm",null,"ratio multipliers",null,2,3,4,5,6,7,8,9,2.5,{"$f":"T11/F11","v":1}]
[null,"Needed ratio",null,null,null,{"$f":"F10/2.5","v":0.13999999999999999},null,null,"new 1st ratio",null,{"$f":"$F$11*K10","v":0.27999999999999997},{"$f":"$F$11*L10","v":0.41999999999999993},{"$f":"$F$11*M10","v":0.55999999999999994},0.7,0.83999999999999986,0.97999999999999987,1.1199999999999999,1.2599999999999998,0.35,{"$f":"F11/T12","v":0.13999999999999999}]
[null,null,null,null,null,null,null,null,"new 2nd ratio",null,{"$f":"1/K10","v":0.5},{"$f":"1/L10","v":0.33333333333333331},0.25,0.2,0.16666666666666666,0.14285714285714285,0.125,0.1111111111111111,0.4,1]
[null,"test numerators",null,24,28,{"$f":"(D13/D14)*(E13/E14)","v":0.27999999999999997}]
[null,"test denom.",null,60,40,null,null,null,"Use of special compound gear selection program recommended for difficult pitches."]
[null,"test ratios",null,{"$f":"D13/D14","v":0.4},{"$f":"E13/E14","v":0.7}]
[]
[null,"Standard Gears",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Gears"]
[null,16,18,24,32,36,40,44,46,48,52,54,56,60,64,72,68,50,28,100]
[16,{"$f":"B$18/$A19","v":1},1.125,1.5,2,2.25,2.5,2.75,2.875,3,3.25,{"$f":"L$18/$A19","v":3.375},3.5,3.75,4,4.5,4.25,3.125,1.75,6.25]
[18,0.88888888888888884,1,1.3333333333333333,1.7777777777777777,2,2.2222222222222223,2.4444444444444446,2.5555555555555554,2.6666666666666665,2.8888888888888888,3,3.1111111111111112,3.3333333333333335,3.5555555555555554,4,3.7777777777777777,2.7777777777777777,1.5555555555555556,5.5555555555555554]
[24,0.66666666666666663,0.75,1,1.3333333333333333,1.5,1.6666666666666667,1.8333333333333333,1.9166666666666667,2,2.1666666666666665,2.25,2.3333333333333335,2.5,2.6666666666666665,3,2.8333333333333335,2.0833333333333335,1.1666666666666667,4.166666666666667]
[32,0.5,0.5625,0.75,1,1.125,1.25,1.375,1.4375,1.5,1.625,1.6875,1.75,1.875,2,2.25,2.125,1.5625,0.875,3.125]
[36,0.44444444444444442,0.5,0.66666666666666663,0.88888888888888884,1,1.1111111111111112,1.2222222222222223,1.2777777777777777,1.3333333333333333,1.4444444444444444,1.5,1.5555555555555556,1.6666666666666667,1.7777777777777777,2,1.8888888888888888,1.3888888888888888,0.77777777777777779,2.7777777777777777]
[40,0.4,0.45,0.6,0.8,0.9,1,1.1000000000000001,1.1499999999999999,1.2,1.3,1.35,1.4,1.5,1.6,1.8,1.7,1.25,0.7,2.5]
[44,0.36363636363636365,0.40909090909090912,0.54545454545454541,0.72727272727272729,0.81818181818181823,0.90909090909090906,1,1.0454545454545454,1.0909090909090908,1.1818181818181819,1.2272727272727273,1.2727272727272727,1.3636363636363635,1.4545454545454546,1.6363636363636365,1.5454545454545454,1.1363636363636365,0.63636363636363635,2.2727272727272729]
[46,0.34782608695652173,0.39130434782608697,0.52173913043478259,0.69565217391304346,0.78260869565217395,0.86956521739130432,0.95652173913043481,1,1.0434782608695652,1.1304347826086956,1.173913043478261,1.2173913043478262,1.3043478260869565,1.3913043478260869,1.5652173913043479,1.4782608695652173,1.0869565217391304,0.60869565217391308,2.1739130434782608]
[48,0.33333333333333331,0.375,0.5,0.66666666666666663,0.75,0.83333333333333337,0.91666666666666663,0.95833333333333337,1,1.0833333333333333,1.125,1.1666666666666667,1.25,1.3333333333333333,1.5,1.4166666666666667,1.0416666666666667,0.58333333333333337,2.0833333333333335]
[52,0.30769230769230771,0.34615384615384615,0.46153846153846156,0.61538461538461542,0.69230769230769229,0.76923076923076927,0.84615384615384615,0.88461538461538458,0.92307692307692313,1,1.0384615384615385,1.0769230769230769,1.1538461538461537,1.2307692307692308,1.3846153846153846,1.3076923076923077,0.96153846153846156,0.53846153846153844,1.9230769230769231]
[54,{"$f":"B$18/$A29","v":0.29629629629629628},0.33333333333333331,0.44444444444444442,0.59259259259259256,0.66666666666666663,0.7407407407407407,0.81481481481481477,0.85185185185185186,0.88888888888888884,0.96296296296296291,{"$f":"L$18/$A29","v":1},1.037037037037037,1.1111111111111112,1.1851851851851851,1.3333333333333333,1.2592592592592593,0.92592592592592593,0.51851851851851849,1.8518518518518519]
[56,0.2857142857142857,0.32142857142857145,0.42857142857142855,0.5714285714285714,0.6428571428571429,0.7142857142857143,0.7857142857142857,0.8214285714285714,0.8571428571428571,0.9285714285714286,0.9642857142857143,1,1.0714285714285714,1.1428571428571428,1.2857142857142858,1.2142857142857142,0.8928571428571429,0.5,1.7857142857142858]
[60,0.26666666666666666,0.3,0.4,0.53333333333333333,0.6,0.66666666666666663,0.73333333333333328,0.76666666666666672,0.8,0.8666666666666667,0.9,0.93333333333333335,1,1.0666666666666667,1.2,1.1333333333333333,0.83333333333333337,0.46666666666666667,1.6666666666666667]
[64,0.25,0.28125,0.375,0.5,0.5625,0.625,0.6875,0.71875,0.75,0.8125,0.84375,0.875,0.9375,1,1.125,1.0625,0.78125,0.4375,1.5625]
[72,0.22222222222222221,0.25,0.33333333333333331,0.44444444444444442,0.5,0.55555555555555558,0.61111111111111116,0.63888888888888884,0.66666666666666663,0.72222222222222221,0.75,0.77777777777777779,0.83333333333333337,0.88888888888888884,1,0.94444444444444442,0.69444444444444442,0.3888888888888889,1.3888888888888888]
[68,0.23529411764705882,0.26470588235294118,0.35294117647058826,0.47058823529411764,0.52941176470588236,0.58823529411764708,0.6470588235294118,0.67647058823529416,0.70588235294117652,0.76470588235294112,0.79411764705882348,0.82352941176470584,0.88235294117647056,0.94117647058823528,1.0588235294117647,1,0.73529411764705888,0.41176470588235292,1.4705882352941178]
[50,0.32,0.36,0.48,0.64,0.72,0.8,0.88,0.92,0.96,1.04,1.08,1.1200000000000001,1.2,1.28,1.44,1.36,1,0.56000000000000005,2]
[28,0.5714285714285714,0.6428571428571429,0.8571428571428571,1.1428571428571428,1.2857142857142858,1.4285714285714286,1.5714285714285714,1.6428571428571428,1.7142857142857142,1.8571428571428572,1.9285714285714286,2,2.1428571428571428,2.2857142857142856,2.5714285714285716,2.4285714285714284,1.7857142857142858,1,3.5714285714285716]
[100,0.16,0.18,0.24,0.32,0.36,0.4,0.44,0.46,0.48,0.52,0.54,0.56000000000000005,0.6,0.64,0.72,0.68,0.5,0.28000000000000003,1]

{"sheet":"English Ratio Table","index":15,"n_rows":37,"n_cols":20,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Gear Selector for Inch Threads on the Logan Changegear Lathe"]
[]
[null,"1) Enter the desired pitch. We assume an 8 TPI leadscrew (can change in cell F11)."]
[null,"2) Select a gear pair from the table that produces the correct ratio. Install as the stud gear and leadscrew gear."]
[null,"3) If a simple ratio is impossible, select two gear pairs, one for each of the new 1st and 2nd ratios. Some fractional multiplier may be needed."]
[null,"4) Install one pair as the stud and outer of the pack nearest the leadscrew, the other pair as the inner of the pack, and the leadscrew gear."]
[null,"Warning- Especially with the finer threads, many combinations can't be physically installed and engage properly. Experimentation required!"]
[]
[null,null,null,null,null,null,null,null,null,null,"Integer",null,null,null,null,null,null,null,"Fractional"]
[null,"Enter desired TPI",null,null,null,8.4700000000000006,"TPI",null,"ratio multipliers",null,2,3,4,5,6,7,8,9,2.5]
[null,"Needed ratio",null,null,null,{"$f":"(1/F10)/0.125","v":0.94451003541912626},null,null,"new 1st ratio",null,{"$f":"$F$11*K10","v":1.8890200708382525},2.8335301062573786,3.778040141676505,4.7225501770956315,5.6670602125147571,6.6115702479338836,7.5560802833530101,8.5005903187721366,2.3612750885478158]
[null,null,null,null,null,null,null,null,"new 2nd ratio",null,{"$f":"1/K10","v":0.5},0.33333333333333331,0.25,0.2,0.16666666666666666,0.14285714285714285,0.125,0.1111111111111111,0.4]
[null,"test numerators",null,1,68,{"$f":"(D13/D14)*(E13/E14)","v":0.94444444444444442}]
[null,"test denom.",null,1,72]
[null,"test ratios",null,{"$f":"D13/D14","v":1},{"$f":"E13/E14","v":0.94444444444444442}]
[]
[null,"Standard Gears",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Gears"]
[null,16,18,24,32,36,40,44,46,48,52,54,56,60,64,72,68,50,28,100]
[16,{"$f":"B$18/$A19","v":1},1.125,1.5,2,2.25,2.5,2.75,2.875,3,3.25,{"$f":"L$18/$A19","v":3.375},3.5,3.75,4,4.5,4.25,3.125,1.75,6.25]
[18,0.88888888888888884,1,1.3333333333333333,1.7777777777777777,2,2.2222222222222223,2.4444444444444446,2.5555555555555554,2.6666666666666665,2.8888888888888888,3,3.1111111111111112,3.3333333333333335,3.5555555555555554,4,3.7777777777777777,2.7777777777777777,1.5555555555555556,5.5555555555555554]
[24,0.66666666666666663,0.75,1,1.3333333333333333,1.5,1.6666666666666667,1.8333333333333333,1.9166666666666667,2,2.1666666666666665,2.25,2.3333333333333335,2.5,2.6666666666666665,3,2.8333333333333335,2.0833333333333335,1.1666666666666667,4.166666666666667]
[32,0.5,0.5625,0.75,1,1.125,1.25,1.375,1.4375,1.5,1.625,1.6875,1.75,1.875,2,2.25,2.125,1.5625,0.875,3.125]
[36,0.44444444444444442,0.5,0.66666666666666663,0.88888888888888884,1,1.1111111111111112,1.2222222222222223,1.2777777777777777,1.3333333333333333,1.4444444444444444,1.5,1.5555555555555556,1.6666666666666667,1.7777777777777777,2,1.8888888888888888,1.3888888888888888,0.77777777777777779,2.7777777777777777]
[40,0.4,0.45,0.6,0.8,0.9,1,1.1000000000000001,1.1499999999999999,1.2,1.3,1.35,1.4,1.5,1.6,1.8,1.7,1.25,0.7,2.5]
[44,0.36363636363636365,0.40909090909090912,0.54545454545454541,0.72727272727272729,0.81818181818181823,0.90909090909090906,1,1.0454545454545454,1.0909090909090908,1.1818181818181819,1.2272727272727273,1.2727272727272727,1.3636363636363635,1.4545454545454546,1.6363636363636365,1.5454545454545454,1.1363636363636365,0.63636363636363635,2.2727272727272729]
[46,0.34782608695652173,0.39130434782608697,0.52173913043478259,0.69565217391304346,0.78260869565217395,0.86956521739130432,0.95652173913043481,1,1.0434782608695652,1.1304347826086956,1.173913043478261,1.2173913043478262,1.3043478260869565,1.3913043478260869,1.5652173913043479,1.4782608695652173,1.0869565217391304,0.60869565217391308,2.1739130434782608]
[48,0.33333333333333331,0.375,0.5,0.66666666666666663,0.75,0.83333333333333337,0.91666666666666663,0.95833333333333337,1,1.0833333333333333,1.125,1.1666666666666667,1.25,1.3333333333333333,1.5,1.4166666666666667,1.0416666666666667,0.58333333333333337,2.0833333333333335]
[52,0.30769230769230771,0.34615384615384615,0.46153846153846156,0.61538461538461542,0.69230769230769229,0.76923076923076927,0.84615384615384615,0.88461538461538458,0.92307692307692313,1,1.0384615384615385,1.0769230769230769,1.1538461538461537,1.2307692307692308,1.3846153846153846,1.3076923076923077,0.96153846153846156,0.53846153846153844,1.9230769230769231]
[54,{"$f":"B$18/$A29","v":0.29629629629629628},0.33333333333333331,0.44444444444444442,0.59259259259259256,0.66666666666666663,0.7407407407407407,0.81481481481481477,0.85185185185185186,0.88888888888888884,0.96296296296296291,{"$f":"L$18/$A29","v":1},1.037037037037037,1.1111111111111112,1.1851851851851851,1.3333333333333333,1.2592592592592593,0.92592592592592593,0.51851851851851849,1.8518518518518519]
[56,0.2857142857142857,0.32142857142857145,0.42857142857142855,0.5714285714285714,0.6428571428571429,0.7142857142857143,0.7857142857142857,0.8214285714285714,0.8571428571428571,0.9285714285714286,0.9642857142857143,1,1.0714285714285714,1.1428571428571428,1.2857142857142858,1.2142857142857142,0.8928571428571429,0.5,1.7857142857142858]
[60,0.26666666666666666,0.3,0.4,0.53333333333333333,0.6,0.66666666666666663,0.73333333333333328,0.76666666666666672,0.8,0.8666666666666667,0.9,0.93333333333333335,1,1.0666666666666667,1.2,1.1333333333333333,0.83333333333333337,0.46666666666666667,1.6666666666666667]
[64,0.25,0.28125,0.375,0.5,0.5625,0.625,0.6875,0.71875,0.75,0.8125,0.84375,0.875,0.9375,1,1.125,1.0625,0.78125,0.4375,1.5625]
[72,0.22222222222222221,0.25,0.33333333333333331,0.44444444444444442,0.5,0.55555555555555558,0.61111111111111116,0.63888888888888884,0.66666666666666663,0.72222222222222221,0.75,0.77777777777777779,0.83333333333333337,0.88888888888888884,1,0.94444444444444442,0.69444444444444442,0.3888888888888889,1.3888888888888888]
[68,0.23529411764705882,0.26470588235294118,0.35294117647058826,0.47058823529411764,0.52941176470588236,0.58823529411764708,0.6470588235294118,0.67647058823529416,0.70588235294117652,0.76470588235294112,0.79411764705882348,0.82352941176470584,0.88235294117647056,0.94117647058823528,1.0588235294117647,1,0.73529411764705888,0.41176470588235292,1.4705882352941178]
[50,0.32,0.36,0.48,0.64,0.72,0.8,0.88,0.92,0.96,1.04,1.08,1.1200000000000001,1.2,1.28,1.44,1.36,1,0.56000000000000005,2]
[28,0.5714285714285714,0.6428571428571429,0.8571428571428571,1.1428571428571428,1.2857142857142858,1.4285714285714286,1.5714285714285714,1.6428571428571428,1.7142857142857142,1.8571428571428572,1.9285714285714286,2,2.1428571428571428,2.2857142857142856,2.5714285714285716,2.4285714285714284,1.7857142857142858,1,3.5714285714285716]
[100,0.16,0.18,0.24,0.32,0.36,0.4,0.44,0.46,0.48,0.52,0.54,0.56000000000000005,0.6,0.64,0.72,0.68,0.5,0.28000000000000003,1]

{"sheet":"Dividing Head","index":16,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Semi-Universal Dividing Head"]
[]
[null,"Main ratio",null,40,":1"]
[]
[null,"Dividing plates",null,null,null,null,"Desired division",null,6,"parts",{"$f":"360/I5","v":60},"deg","Cannot do:"]
[null,null,null,null,null,null,"Crank turns",null,{"$f":"TRUNC(D3/I5, 0)","v":6},"turns"]
[null,null,null,null,null,null,null,null,"plus"]
[null,"holes","deg in","deg out","division",null,"tot. holes",null,"# of holes",null,null,null,51,83]
[null,null,null,null,null,null,null,null,null,null,null,null,53,87]
[null,15,{"$f":"360/B10","v":24},{"$f":"(1/$D$3)*C10","v":0.60000000000000009},{"$f":"360/D10","v":599.99999999999989},null,{"$f":"E10/$I$5","v":99.999999999999986},null,{"$f":"MOD($D$3/$I$5, 1)*B10","v":10.000000000000004},null,null,null,57,89]
[null,16,22.5,0.5625,640,null,106.66666666666667,null,10.666666666666671,null,null,null,59,91]
[null,17,21.176470588235293,0.52941176470588236,680,null,113.33333333333333,null,11.333333333333339,null,null,null,61,93]
[null,18,20,0.5,720,null,120,null,12.000000000000005,null,null,null,63,96]
[null,19,18.94736842105263,0.47368421052631576,760,null,126.66666666666667,null,12.666666666666671,null,null,null,67,97]
[null,20,18,0.45,800,null,133.33333333333334,null,13.333333333333339,null,null,null,69,99]
[null,null,null,null,null,null,null,null,null,null,null,null,71]
[null,21,{"$f":"360/B17","v":17.142857142857142},{"$f":"(1/$D$3)*C17","v":0.4285714285714286},{"$f":"360/D17","v":839.99999999999989},null,{"$f":"E17/$I$5","v":139.99999999999997},null,{"$f":"MOD($D$3/$I$5, 1)*B17","v":14.000000000000007},null,null,null,73]
[null,23,15.652173913043478,0.39130434782608697,920,null,153.33333333333334,null,15.333333333333339,null,null,null,77]
[null,27,13.333333333333334,0.33333333333333337,1079.9999999999998,null,179.99999999999997,null,18.000000000000007,null,null,null,79]
[null,29,12.413793103448276,0.31034482758620691,1160,null,193.33333333333334,null,19.333333333333343,null,null,null,81]
[null,31,11.612903225806452,0.29032258064516131,1240,null,206.66666666666666,null,20.666666666666675]
[null,33,10.909090909090908,0.27272727272727271,1320,null,220,null,22.000000000000011]
[]
[null,37,{"$f":"360/B24","v":9.7297297297297298},{"$f":"(1/$D$3)*C24","v":0.24324324324324326},{"$f":"360/D24","v":1480},null,{"$f":"E24/$I$5","v":246.66666666666666},null,{"$f":"MOD($D$3/$I$5, 1)*B24","v":24.666666666666679}]
[null,39,9.2307692307692299,0.23076923076923075,1560,null,260,null,26.000000000000011]
[null,41,8.7804878048780495,0.21951219512195125,1639.9999999999998,null,273.33333333333331,null,27.333333333333346]
[null,43,8.3720930232558146,0.20930232558139539,1719.9999999999998,null,286.66666666666663,null,28.666666666666679]
[null,47,7.6595744680851068,0.19148936170212769,1879.9999999999998,null,313.33333333333331,null,31.333333333333346]
[null,49,7.3469387755102042,0.18367346938775511,1960,null,326.66666666666669,null,32.666666666666679]
[]
[null,54,{"$f":"360/B31","v":6.666666666666667},{"$f":"(1/$D$3)*C31","v":0.16666666666666669},{"$f":"360/D31","v":2159.9999999999995},null,{"$f":"E31/$I$5","v":359.99999999999994},null,{"$f":"MOD($D$3/$I$5, 1)*B31","v":36.000000000000014},"user fab."]
[null,63,{"$f":"360/B32","v":5.7142857142857144},{"$f":"(1/$D$3)*C32","v":0.14285714285714288},{"$f":"360/D32","v":2519.9999999999995},null,{"$f":"E32/$I$5","v":419.99999999999994},null,{"$f":"MOD($D$3/$I$5, 1)*B32","v":42.000000000000021},"user fab."]

{"sheet":"Knurling","index":17,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Knurling"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Number of lines or cycles around the knurling tool",null,null,null,null,50]
[null,"Nominal diameter of knurl",null,null,null,null,0.75,"in"]
[null,"Diametrical pitch of knurl",null,null,null,null,{"$f":"G11/G12","v":66.666666666666671}]
[null,"Circular pitch on nominal diameter of knurl",null,null,null,null,{"$f":"PI()/G13","v":4.7123889803846894E-2},"in",{"$f":"G14*25.4","v":1.1969468010177111},"mm"]
[]
[null,"Blank diameter increments",null,null,null,null,{"$f":"1/G13","v":1.4999999999999999E-2},"in"]
[]
[null,"Desired blank diameter",null,null,null,null,1.4850000000000001,"in"]
[null,"Division remainder",null,null,null,null,{"$f":"MOD(G18, G16)","v":1.5265566588595902E-16},"in"]
[]
[null,"Plus 1 line/cycle blank diameter",null,null,null,null,{"$f":"G22+G16","v":1.4999999999999998},"in"]
[null,"Nominal blank diameter",null,null,null,null,{"$f":"G18-G19","v":1.4849999999999999},"in"]
[null,"Minus 1 line/cycle blank diameter",null,null,null,null,{"$f":"G22-G16","v":1.47},"in"]
[null,"Minus 2 line/cycle blank diameter",null,null,null,null,{"$f":"G22-G16-G16","v":1.4550000000000001},"in"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Number of lines/cycles",null,null,null,null,75]
[null,"Distance over pattern of lines/cycles",null,null,null,null,3.5350000000000001,"in"]
[null,"Circular pitch",null,null,null,null,{"$f":"G34/G33","v":4.7133333333333333E-2},"in",{"$f":"G35*25.4","v":1.1971866666666666},"mm"]
[null,"Diametrical pitch",null,null,null,null,{"$f":"PI()/G35","v":66.653309482103111}]
[]
[null,"Blank diameter increments",null,null,null,null,{"$f":"1/G36","v":1.5003005968796E-2},"in"]
[]
[null,"Desired blank diameter",null,null,null,null,0.625,"in"]
[null,"Division remainder",null,null,null,null,{"$f":"MOD(G40, G38)","v":9.8767552793640068E-3},"in"]
[]
[null,"Plus 1 line/cycle blank diameter",null,null,null,null,{"$f":"G44+G38","v":0.63012625068943195},"in"]
[null,"Nominal blank diameter",null,null,null,null,{"$f":"G40-G41","v":0.61512324472063595},"in"]
[null,"Minus 1 line/cycle blank diameter",null,null,null,null,{"$f":"G44-G38","v":0.60012023875183995},"in"]
[null,"Minus 2 line/cycle blank diameter",null,null,null,null,{"$f":"G44-G38-G38","v":0.58511723278304395},"in"]

{"sheet":"Cyl. Square","index":18,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Cylinderical Square Dimensions",null,null,null,null,null,null,"Rectangular Parallel Square Check"]
[]
[null,"Check the square:",null,null,null,null,null,null,"Check the square:"]
[null,"Upper ring diameter",null,null,0.99199999999999999,"in",null,null,"Zero square comparator on side A",null,null,null,0,"in"]
[null,"Lower ring diameter",null,null,0.99219999999999997,"in",null,null,"Measure side B",null,null,null,2.9999999999999997E-4,"in"]
[null,"Difference per side",null,null,{"$f":"(E5-E4)/2","v":9.9999999999988987E-5},"in",null,null,"Error is 1/2",null,null,null,{"$f":"M5/2","v":1.4999999999999999E-4},"in"]
[null,"Length, ctr-ctr on rings",null,null,2.62,"in",null,null,"Length, ctr-ctr of square comparator",null,null,null,4.5,"in"]
[null,"Error",null,null,{"$f":"DEGREES(ATAN(E6/E7))","v":2.1868618124142496E-3},"degrees",null,null,"Angle",null,null,null,{"$f":"DEGREES(ATAN(M6/M7))","v":1.9098593163953883E-3},"deg"]
[null,null,null,null,{"$f":"E8*60","v":0.13121170874485497},"arc-min",null,null,null,null,null,null,{"$f":"M8*60","v":0.11459155898372329},"arc-min"]
[null,null,null,null,{"$f":"E8*3600","v":7.8727025246912987},"arc-sec",null,null,null,null,null,null,{"$f":"M8*3600","v":6.875493539023398},"arc-sec"]
[null,null,null,null,null,null,null,null,"Fix the square"]
[null,"Use the square:",null,null,null,null,null,null,"error",null,null,null,{"$f":"M6/M7","v":3.3333333333333328E-5},"in/in"]
[null,"Gap at top or bottom",null,null,1E-3,"in",null,null,"length of base",null,null,null,1.7629999999999999,"in"]
[null,"Height",null,null,5,"in",null,null,"error over base to grind or lap",null,null,null,{"$f":"M12*M13","v":5.8766666666666654E-5},"in"]
[null,"Angle",null,null,{"$f":"DEGREES(ATAN(E13/E14))","v":1.1459155749827723E-2},"deg"]
[null,null,null,null,{"$f":"E15*60","v":0.68754934498966336},"arc-min"]
[null,null,null,null,{"$f":"E15*3600","v":41.252960699379805},"arc-sec"]
[]
[null,"Do it in reverse"]
[null,"Length, ctr-ctr",null,null,4.5,"in"]
[null,"Angle",null,null,6.9,"arc-sec"]
[null,null,null,null,{"$f":"E21/60","v":0.115},"arc-min"]
[null,null,null,null,{"$f":"E21/3600","v":1.9166666666666668E-3},"deg"]
[null,"Gap",null,null,{"$f":"TAN(RADIANS(E23))*E20","v":1.5053464804066268E-4},"in"]

{"sheet":"Sine Bar","index":19,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Sine Bar"]
[]
[null,"Distance between cylinders",null,null,null,2.1,"in"]
[]
[null,"Desired angle",null,null,null,7.5,"degrees"]
[]
[null,"Spacer or gage blocks",null,null,null,{"$f":"F3*SIN(RADIANS(F5))","v":0.27410500366210833},"in"]

{"sheet":"Find Nominal","index":20,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Find the Nominal for Unsymmetrical Tolerances"]
[]
[null,"Use any units here, all positive",null,null,null,null,"If it was inches, here's metric",null,null,null,null,"If it was metric, here's inches"]
[]
[null,"Dimension","Plus","Minus",null,null,"Dimension","Plus","Minus",null,null,"Dimension","Plus","Minus"]
[null,1,0.1,0.05,null,null,{"$f":"B6*25.4","v":25.4},{"$f":"C6*25.4","v":2.54},1.27,null,null,{"$f":"B6/25.4","v":3.937007874015748E-2},{"$f":"C6/25.4","v":3.9370078740157488E-3},1.9685039370078744E-3]
[]
[null,"Nominal","Plus","Minus",null,null,"Nominal","Plus","Minus",null,null,"Nominal","Plus","Minus"]
[null,{"$f":"(B6+C6)-C9","v":1.0250000000000001},{"$f":"(C6+D6)/2","v":7.5000000000000011E-2},{"$f":"C9","v":7.5000000000000011E-2},null,null,{"$f":"B9*25.4","v":26.035000000000004},1.9050000000000002,1.9050000000000002,null,null,{"$f":"B9/25.4","v":4.0354330708661422E-2},2.9527559055118114E-3,2.9527559055118114E-3]

{"sheet":"Bolt Torque from Tensile","index":21,"n_rows":29,"n_cols":26,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Bolt Tensile Force vs. Torque"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Various SHCS"]
[null,null,null,null,null,null,null,"SI",null,"enter here!",null,null,null,null,null,"#4-40","#6-32","#8-32","#10-32","1/4-20","M1.4"]
[null,"Tensile force, F",null,null,null,null,{"$f":"J11*9.80665","v":0.99047165000000004},"N",null,0.10100000000000001,"kgf",null,{"$f":"J11*2.20462262","v":0.22266688462000001},"lbf"]
[null,"Thread pitch, P",null,null,null,null,{"$f":"J12/1000","v":1E-3},"m",null,1,"mm",null,{"$f":"J12/25.4","v":3.937007874015748E-2},"in",null,0.63500000000000001,0.79374999999999996,0.79374999999999996,0.79374999999999996,1.27,0.3,null,null,null,"OD",2.4889999999999999]
[null,"COF int to ext threads, µT",null,null,null,null,{"$f":"J13","v":0.2},null,null,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID",1.4]
[null,"Effective radius of above, RT",null,null,null,null,{"$f":"J14/1000","v":6.0257000000000008E-4},"m",null,0.60257000000000005,"mm",null,{"$f":"J14/25.4","v":2.3723228346456696E-2},"in",null,null,null,null,2.1551999999999998,null,0.60257000000000005,null,null,null,"Average",{"$f":"AVERAGE(Z12, Z13)","v":1.9444999999999999}]
[null,"Thread flank angle, α",null,null,null,null,{"$f":"J15","v":30},"°",null,30,"°",null,null,null,null,null,null,null,null,null,null,null,null,null,"Radius",{"$f":"Z14/2","v":0.97224999999999995}]
[null,"COF fastener to bearing surface, µB",null,null,null,null,{"$f":"J16","v":0},null,null,0]
[null,"Effective radius of above, RB",null,null,null,null,{"$f":"J17/1000","v":9.9999999999999995E-7},"m",null,1E-3,"mm",null,{"$f":"J17/25.4","v":3.9370078740157485E-5},"in",null,null,null,null,3.048,null,0.92149999999999999]
[null,"Total input torque, T1",null,null,null,null,{"$f":"G11*((G12/(2*PI()))+(G13*G14/COS(RADIANS(G15)))+(G16*G17))","v":2.9547009763822925E-4},"N·m",null,{"$f":"G18*10197.162129779","v":3.012956490118655},"g·cm",null,{"$f":"G18*8.850745767","v":2.6151307159466342E-3},"lb·in"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G18*141.611932278","v":4.1842091456918973E-2},"oz·in"]
[]
[]
[null,"Number of bolts",null,null,null,null,null,null,null,null,null,null,22]
[null,"Area of clamped surface",null,null,null,null,null,null,null,null,null,null,1.7,"in²"]
[null,"Force",null,null,null,null,null,null,null,null,null,null,{"$f":"M11*M22","v":4.8986714616400002},"lbf"]
[null,"Force/area",null,null,null,null,null,null,null,null,null,null,{"$f":"M24/M23","v":2.8815714480235295},"psi"]
[]
[]
[]
[null,"Test to get F from T1",null,null,null,null,{"$f":"(G18-(G13*G14/COS(RADIANS(G15))))/(G12/(2*PI()))","v":0.98214050986614965}]

{"sheet":"Gage Blocks","index":22,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Selecting Gage Blocks",null,"BIG WIP!"]
[]
[]
[null,"Needed stack dimension",3.0613000000000001,null,null,"Available gage blocks 81 pcs.",null,"Comments to automate"]
[]
[null,"Block to eliminate ten-thousandths digit",0.1003,null,null,".1001 to .1009 by .0001",null,"match last digit or zero, subtract from total- this always works"]
[null,"Difference",{"$f":"C4-C6","v":2.9610000000000003},null,null,null,null,"note that set cannot go below 0.1\""]
[]
[null,"Block to eliminate thousandths digit",0.14099999999999999,null,null,".101 to .149 by .001"]
[null,"Difference",{"$f":"C7-C9","v":2.8200000000000003}]
[]
[null,"Block to eliminate hundredths digit",0.12,null,null,null,null,"if digit isn't 0 or 5, adjust thou to make it so"]
[null,"Difference",{"$f":"C10-C12","v":2.7}]
[]
[null,"Block to eliminate tenths digit",0.7]
[null,"Difference",{"$f":"C13-C15","v":2}]
[]
[null,"Block to eliminate inches",2,null,null,null,null,"must be 2, 3 or 4- this always works"]
[null,"Difference",{"$f":"C16-C18","v":0},null,null,0.05]
[null,null,null,null,null,0.1]
[null,null,"Done!",null,null,".1001 to .1009 by .0001"]
[null,null,null,null,null,".101 to .149 by .001"]
[null,null,null,null,null,".15 to 1 by .05"]
[null,null,null,null,null,2]
[null,null,null,null,null,3]
[null,null,null,null,null,4]
[]
[]
[]
[]
[]
[null,"Dimension to stack",3.0613000000000001]
[]
[null,"Block to eliminate inches",2,null,null,"use 1\" less then value"]
[null,"Difference",{"$f":"$C$4-C34","v":1.0613000000000001}]
[]
[null,"Block to eliminate tenths digit",0.7,null,null,"do last?"]
[null,"Difference",{"$f":"C35-C37","v":0.36130000000000018}]
[]
[null,"Block to eliminate hundredths digit",0.16,null,null,"use +0.1"]
[null,"Difference",{"$f":"C38-C40","v":0.20130000000000017}]
[]
[null,"Block to eliminate thousandths digit",0.10100000000000001]
[null,"Difference",{"$f":"C41-C43","v":0.10030000000000017}]
[]
[null,"Block to eliminate ten-thousandths digit",0.1003]
[null,"Difference",{"$f":"C44-C46","v":1.6653345369377348E-16}]

{"sheet":"SFPM","index":23,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["SFPM"]
[]
[null,"Cutter or work diameter",0.45,"in"]
[null,"RPM",205]
[null,"SFPM",{"$f":"(PI()*C3/12)*C4","v":24.150993524471534},null,{"$f":"C5*5.0799999","v":122.68704468921604},"mm/s"]
[]
[]
[]
[null,"SFPM",24.2,null,{"$f":"C9*5.0799999","v":122.93599757999999},"mm/s"]
[null,"RPM",{"$f":"C9/(C3*PI()*(1/12))","v":205.41597988393957}]

{"sheet":"Thd Length","index":24,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Minimum thread engagement"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Numbers from example"]
[null,"ultimate strength, screw",621,"Mpa",null,null,null,null,null,null,null,800]
[null,"yield point, screw",241,"Mpa",null,null,null,null,null,null,null,640]
[null,"yield point, tapped hole",290,"MPa",null,null,null,null,null,null,null,290]
[null,"ultimate strength, tapped hole",435,"MPa",null,null,null,null,null,null,null,435]
[null,"nominal diameter",2,"mm",null,null,null,null,null,null,null,16]
[null,"stress section",2.1475900000000001,"mm^2",null,null,null,null,null,null,null,156.69999999999999]
[null,"pitch",0.4,"mm",null,null,null,null,null,null,null,2]
[null,"pitch diameter",{"$f":"C12-0.6495*C14","v":1.7402},"mm",null,null,null,null,null,null,null,14.701000000000001]
[]
[null,"minimum engagement, tapped hole",{"$f":"(C8/C10)*(2*C13)/(0.6*PI()*C12)","v":2.4397417171237166},"mm",null,null,null,null,null,null,null,28.6662]
[null,"minimum engagement, screw",{"$f":"C8/C9*(2*C13)/(0.6*PI()*C15)","v":3.3740820460178789},"mm",null,null,null,null,null,null,null,14.1371]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pitch diameter",1.7402]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"minor diameter",1.5669999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H",0.34639999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AS",{"$f":"(PI()/4)*((P33+P34)/2)^2","v":2.1475872087909118}]

{"sheet":"Sheet1","index":25,"n_rows":19,"n_cols":19,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Hertzian Contact Stress- 2 Spheres"]
[]
[]
[null,null,null,"Sphere 1","Sphere 2",null,null,null,null,null,null,null,null,null,null,"Matl.","Poisson's","Young's","Max. stress"]
[null,"Poisson's ratio",null,0.28999999999999998,0.39,null,null,null,null,null,null,null,null,null,null,"420 SS",0.24,200,1360]
[null,"Young's modulus, Gpa",null,386,3.6,null,null,null,null,null,null,null,null,null,null,"440C SS",0.28999999999999998,200,1900]
[null,"Diameter, mm",null,3,10000000000,null,null,null,null,null,null,null,null,null,null,"52100 bearing"]
[null,"Force, N",null,null,2,null,null,null,null,null,null,null,null,null,null,"Tantung \"G\"",0.3,265,600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6061-T6",0.33,68.900000000000006,255]
[null,"Equivalent modulus, Ee",null,null,{"$f":"1/((1-D5^2)/(D6*1000000000)+(1-E5^2)/(E6*1000000000))","v":4203436654.306417},"Pa",null,null,null,null,null,null,null,null,null,"C54400 Bronze",0.32,103,303]
[null,"Equivalent radius, Re",null,null,{"$f":"1/((1/(D7/2/1000))+(1/(D7/2/1000))+(1/(E7/2/1000))+(1/(E7/2/1000)))","v":7.4999999977500009E-4},"m",null,null,null,null,null,null,null,null,null,"Alumina 995",0.2,370,240]
[null,"Contact radius, a",null,null,{"$f":"((3*E8*E11)/(2*E10))^(1/3)","v":8.1194386314260904E-5},"m","P",null,null,null,null,null,null,null,null,"Zirconia YZTP"]
[null,"Contact radius, a",null,null,{"$f":"E12*1000000","v":81.19438631426091},"µm","P",null,null,null,null,null,null,null,null,"Delrin, 150E",0.35,2.9,69]
[null,"Contact diameter, 2a",null,null,{"$f":"2*E13","v":162.38877262852182},"µm",null,null,null,null,null,null,null,null,null,"Sapphire",0.28999999999999998,386,760]
[null,"Deflection, δ",null,null,{"$f":"0.5 * ((1/E11)^(1/3)) * (((3*E8)/(2*E10))^(2/3))","v":4.3950189139514668E-6},"m","P",null,null,null,null,null,null,null,null,"PEEK",0.39,3.6,95]
[null,"Deflection, δ",null,null,{"$f":"E15*1000000000","v":4395.0189139514669},"nm","P"]
[null,"Contact stress, q",null,null,{"$f":"0.000001*(E12*E10)/(PI()*E11)","v":144.850291892418},"MPa","P"]
[null,"Depth max shear, z",null,{"$f":"E12*SQRT((2*(1+D5))/(7-2*D5))","v":5.1471679888190854E-5},{"$f":"E12*SQRT((2*(1+E5))/(7-2*E5))","v":5.4281671102070451E-5},"m","no"]
[null,"Depth max shear, z",null,{"$f":"1000000*D18","v":51.471679888190856},{"$f":"1000000*E18","v":54.281671102070455},"µm","no",19.16]

{"sheet":"Balancing I","index":26,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Single Plane Balancing"]

{"sheet":"Balancing II","index":27,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Balancing Equations",null,null,null,null,"Enter data in red, results returned in blue cells"]
[]
[null,"The amplitude and mass can be in any units, as long as you are consistant."]
[]
[null,"R0, amplitude, unbalanced",null,null,null,1.05,"units","Vibration amplitude reading at the rotational frequency only"]
[null,"R1, amplitude w/ mass on reference line",null,null,null,0.92,"units","Same with an arbitrary mass added at an arbitrary zero line"]
[null,"R2, amplitude w/ mass rotated positive",null,null,null,1.5,"units","This direction defines the positve angle, suggest 90 - 120 degrees from reference line"]
[null,"R3, amplitude w/ mass rotated negative",null,null,null,0.95,"units","Shift the mass to the other side of the reference line by the same amount"]
[null,"Angle mass was shifted from ref line",null,null,null,120,"degrees","120 degrees is optimum as mass locations will be equally spaced for 3 runs"]
[]
[null,"X result",null,null,null,{"$f":"((2*F6^2)-(F7^2)-(F8^2))/((4*F5^2)*(1-COS(RADIANS(F9))))","v":-0.22066515495086922}]
[null,"Y result",null,null,null,{"$f":"((F7^2)-(F8^2))/((4*F5^2)*(SIN(RADIANS(F9))))","v":0.3528251645047713}]
[null,"U/T ratio of unbalance to test mass",null,null,null,{"$f":"1/SQRT(F11^2+F12^2)","v":2.4029943696208473}]
[null,"Test mass",null,null,null,2.35,"units","Could be grams, ounces or inches of adhesive weight strip"]
[null,"Material to be removed or added",null,null,null,{"$f":"F13*F14","v":5.6470367686089915},"units"]
[null,"Angle of material removal",null,null,null,{"$f":"DEGREES(ATAN2(F11,F12))","v":122.02282936791238},"degrees","Note we use ATAN2 here so the quadrants come out correctly"]
[null,"Or, angle of material addition",null,null,null,{"$f":"IF(F16<>0, -SIGN(F16)*(180-ABS(F16)), 180)","v":-57.977170632087621},"degrees"]
[]
[null,"If a single removal or addition is not possible, say on a multi-bladed fan assembly, two balance weights can be calculated as follows:"]
[]
[null,"Angle away from nominal for mass 1",null,null,null,30,"degrees",null,"Angle 1 abs",null,-60,"degrees"]
[null,"Angle other way from nominal for mass 2",null,null,null,30,"degrees",null,"Angle 2 abs",null,-90,"degrees"]
[null,"Mass 1",null,null,null,{"$f":"F15*((SIN(RADIANS(F22)))/(SIN(RADIANS(F21+F22))))","v":3.2603181984801153},"units",null,"Mass 1",null,null,"units"]
[null,"Mass 2",null,null,null,{"$f":"F15*((SIN(RADIANS(F21)))/(SIN(RADIANS(F21+F22))))","v":3.2603181984801153},"units",null,"Mass 2",null,null,"units"]

{"sheet":"Vibration I","index":28,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Vibration Formulas, sinusoidal",null,null,null,null,"WIP- double check results!"]
[]
[null,"Pi Vibrometer reads in Velocity: mm/s time a range switch setting of 5, 25 or 125"]
[]
[null,"Reading in volts peak to peak",null,null,0.4,"volts"]
[null,"Range switch setting",null,null,25,"X"]
[null,"Velocity",null,null,{"$f":"E5*E6","v":10},"mm/s"]
[null,"Velocity",null,null,{"$f":"E7/1000","v":0.01},"m/s "]
[null,"Frequency, f",null,null,100,"Hz"]
[null,"Standard gravity, g",null,null,9.8066499999999994,"m/s^2"]
[]
[null,"Displacement, Dp-p",null,null,{"$f":"E8/(PI()*E9)","v":3.1830988618379067E-5},"m"]
[null,"Displacement, Dp-p",null,null,{"$f":"E12*1000000","v":31.830988618379067},"um"]
[]
[null,"Acceleration",null,null,{"$f":"(2*PI()*E9*E8)","v":6.2831853071795862},"m/s^2"]
[null,"Acceleration",null,null,{"$f":"E15/E10","v":0.64070659268757291},"g"]
[]
[]
[]
[null,"Accelerometers read (duh!) acceleration: mm/s^2 or similar"]
[]
[null,"Acceleration",null,null,98.066500000000005,"m/s^2",{"$f":"E22/E10","v":10.000000000000002},"g"]
[null,"Frequency",null,null,5,"Hz"]
[]
[null,"Displacement, Dp-p",null,null,{"$f":"(E22)/(2*PI()^2*E23^2)","v":0.19872427711322635},"m",{"$f":"E25/0.0254","v":7.8237904375285972},"in"]
[null,"Displacement, Dp-p",null,null,{"$f":"E25*1000000","v":198724.27711322636},"um"]
[]
[null,"Velocity",null,null,{"$f":"PI()*E23*E25","v":3.1215536453442709},"m/s",{"$f":"E28/0.0254","v":122.89581280882958},"in/s"]
[null,"Velocity",null,null,{"$f":"E28*1000","v":3121.553645344271},"mm/s"]

{"sheet":"Vibration II","index":29,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Harmonic Motion Speed and Acceleration",null,null,null,null,null,"MKS"]
[]
[null,null,"Frequency",null,null,333000,"Hz"]
[null,null,"Amplitude, p-p",null,null,2,"um",null,{"$f":"F7/1000000","v":1.9999999999999999E-6},"m"]
[]
[null,null,"omega",null,null,{"$f":"2*PI()*F6","v":2092300.7072908022},"rad/sec"]
[null,null,"Velocity at zero crossing",null,null,{"$f":"-(I7/2)*F9*SIN(F9*J10)","v":2.0923007072908022},"m/sec",null,"eval at t=",{"$f":"(1/F6)*0.75","v":2.2522522522522524E-6},"sec (at zero crossing)"]
[null,null,"Acceleration at peaks",null,null,{"$f":"-(I7/2)*F9^2*COS(F9*J11)","v":4377722.2497295905},"m/sec^2",null,"eval at t=",{"$f":"(1/F6)*0.5","v":1.5015015015015015E-6},"sec (at peak)"]
[]
[]
[null,null,"Spring Mass Speed and Acceleration"]
[]
[null,null,"Mass",null,null,5.7000000000000002E-3,"grams",null,{"$f":"F16/1000","v":5.7000000000000005E-6},"kg"]
[null,null,"Force",null,null,5,"grms f",null,{"$f":"F17*0.00980665","v":4.903325E-2},"N"]
[]
[null,null,"Acceleration",null,null,{"$f":"I17/I16","v":8602.3245614035077},"m/sec^2",null,"must be greater than above to remain in contact"]
[]
[]
[null,null,"Resonant Frequency of Spring and Mass",null,null,null,null,null,null,null,null,"Static Deflection (uses stiffness at left)"]
[]
[null,null,"Mass",null,null,135,"grams",null,{"$f":"F24/1000","v":0.13500000000000001},"kg",null,"Force",null,5,"grams"]
[null,null,"Stiffness",null,null,null,null,null,75000,"N/m"]
[null,null,null,null,null,null,null,null,null,null,null,"Deflection",null,{"$f":"1000000*(N24*0.00980665)/I25","v":0.65377666666666667},"um"]
[null,null,"omega",null,null,{"$f":"SQRT(I25/I24)","v":745.35599249992981},"rad/sec"]
[null,null,"Natural frequency",null,null,{"$f":"F27/(2*PI())","v":118.6270905695295},"Hz"]
[]
[]
[null,null,"Wear Pad Mass",null,null,null,null,null,null,null,null,"Spring Compression Converter (k)"]
[]
[null,null,"diameter",null,null,0.1,"in",null,null,null,null,"Force",454,"grams"]
[null,null,"thickness",null,null,3.2000000000000001E-2,"in",null,null,null,null,"Distance",240,"um",null,2.5000000000000001E-3,"in ="]
[null,null,"density",null,null,0.05,"lbs/in^3",null,null,null,null,null,null,null,null,{"$f":"P34*25400","v":63.5},"um"]
[null,null,null,null,null,null,null,null,null,null,null,"k",{"$f":"9806.65*M33/M34","v":18550.912916666664},"N/m"]
[null,null,"area",null,null,{"$f":"PI()*(F33/2)^2","v":7.8539816339744835E-3},"in^2"]
[null,null,"volume",null,null,{"$f":"F37*F34","v":2.5132741228718348E-4},"in^3"]
[null,null,"mass",null,null,{"$f":"F38*F35","v":1.2566370614359175E-5},"lbs"]
[null,null,"mass",null,null,{"$f":"F39*453.5924","v":5.7000102062566525E-3},"grams",null,{"$f":"F40/1000","v":5.7000102062566523E-6},"kg"]
[]
[]
[null,null,"Wear Pad Density, squares"]
[]
[null,null,"length",null,null,0.18,"in"]
[null,null,"width",null,null,0.18,"in"]
[null,null,"thickness",null,null,6.3E-2,"in"]
[null,null,"mass",null,null,3.7499999999999999E-2,"grams"]
[]
[null,null,"volume",null,null,{"$f":"F45*F46*F47","v":2.0412E-3},"in^3"]
[null,null,"density",null,null,{"$f":"(F48*0.0022046)/F50","v":4.0501910640799534E-2},"lbs/in^3"]

{"sheet":"Taper Measurement","index":30,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Internal Taper Angle Measurement with Balls",null,null,null,null,null,"Enter data in blue cells, do not alter formula results in red cells."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"d1",null,10.786,"mm","distance to a ball from the reference point"]
[null,"d2",null,11.535,"mm","distance to the other ball from the reference point- this must be the larger number!"]
[]
[null,"r1",null,1.190625,"mm","radius of smaller ball"]
[null,"r2",null,1.5,"mm","radius of larger ball"]
[]
[null,"delta d",null,{"$f":"D11-D10","v":0.74900000000000055},"mm","height difference between OD of balls"]
[]
[null,"A",null,{"$f":"DEGREES(2*ASIN((D14-D13)/((D11-D10)+(D13-D14))))","v":89.4532232877702},"deg","total included angle of taper"]

{"sheet":"Beam Deflection","index":31,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Beam Deflection for Various Beams"]
[]
[null,null,null,"Round",null,null,null,null,null,"Rectangular",null,null,null,null,null,"Tube"]
[]
[null,"both ends supported",null,null,"1 end supported",null,null,"both ends supported",null,null,"1 end supported",null,null,"both ends supported",null,null,"1 end supported"]
[]
[null,"Length",12,"in",12,"in",null,"Length",12,"in",0.98399999999999999,"in",null,"Length",12,"in",12,"in"]
[null,"Width",{"$f":"NA()","v":{"$error":"#N/A"}},null,{"$f":"NA()","v":{"$error":"#N/A"}},null,null,"Width",1,"in",7.8E-2,"in",null,"OD",1,"in",1,"in"]
[null,"Height",{"$f":"NA()","v":{"$error":"#N/A"}},null,{"$f":"NA()","v":{"$error":"#N/A"}},null,null,"Height",1,"in",5.6299999999999996E-3,"in",null,"ID",0.5,"in",0.5,"in"]
[null,"Modulus",30000000,"psi",30000000,"psi",null,"Modulus",30000000,"psi",546000,"psi",null,"Modulus",30000000,"psi",30000000,"psi"]
[null,"Diameter",0.5,"in",0.5,"in",null,"Diameter",{"$f":"NA()","v":{"$error":"#N/A"}},"in",{"$f":"NA()","v":{"$error":"#N/A"}},"in",null,"Diameter",{"$f":"NA()","v":{"$error":"#N/A"}},"in",{"$f":"NA()","v":{"$error":"#N/A"}},"in"]
[null,"Load",10,"lbs (ctr)",5,"lbs (end)",null,"Load",10,"lbs (ctr)",3.2909999999999998E-4,"lbs (end)",null,"Load",10,"lbs (ctr)",5,"lbs (end)"]
[]
[null,"Deflection",{"$f":"(C12*C7^3)/(48*C10*C19)","v":3.9113918814264199E-3},"in",{"$f":"(E12*E7^3)/(3*E10*E19)","v":3.1291135051411359E-2},"in",null,"Deflection",{"$f":"(I12*I7^3)/(48*I10*I19)","v":1.44E-4},"in",{"$f":"(K12*K7^3)/(3*K10*K19)","v":0.16502917894462768},"in",null,"Deflection",{"$f":"(O12*O7^3)/(48*O10*O19)","v":2.6075945876176133E-4},"in",{"$f":"(Q12*Q7^3)/(3*Q10*Q19)","v":2.0860756700940906E-3},"in"]
[null,"Resonance",{"$f":"NA()","v":{"$error":"#N/A"}},null,{"$f":"(0.5/PI())*SQRT((3*E10*E19*386)/(E12*E7^3))","v":17.67677872321822},"Hz",null,"Resonance",{"$f":"NA()","v":{"$error":"#N/A"}},null,{"$f":"(0.5/PI())*SQRT((3*K10*K19*386)/(K12*K7^3))","v":7.6972114016600131},"Hz",null,"Resonance",{"$f":"NA()","v":{"$error":"#N/A"}},null,{"$f":"(0.5/PI())*SQRT((3*Q10*Q19*386)/(Q12*Q7^3))","v":68.461869609617779},"Hz"]
[]
[]
[null,"Intermediate results",null,null,null,null,null,"Intermediate results",null,null,null,null,null,"Intermediate results"]
[null,"I ",{"$f":"(PI()*C11^4)/64","v":3.0679615757712823E-3},null,{"$f":"(PI()*E11^4)/64","v":3.0679615757712823E-3},null,null,"I ",{"$f":"(I8*I9^3)/12","v":8.3333333333333329E-2},null,{"$f":"(K8*K9^3)/12","v":1.1599480554999999E-9},null,null,"I ",{"$f":"(PI()*(O8^4-O9^4))/64","v":4.6019423636569232E-2},null,{"$f":"(PI()*(Q8^4-Q9^4))/64","v":4.6019423636569232E-2}]
[null,null,null,null,null,null,null,"H",{"$f":"I9/2","v":0.5},null,{"$f":"K9/2","v":2.8149999999999998E-3}]
[]
[]
[null,"Modulus of Elasticity in Tension (X10^6 psi)"]
[]
[null,"Silicon Carbide",null,"13-95"]
[null,"Tungsten Carbide",null,"65-94"]
[null,"Alumina",null,"30-50"]
[null,"Steel",null,"29-30"]
[null,"Brass",null,"15-18"]
[null,"Aluminum (6000)",null,10]
[null,"Magnesium",null,6]
[null,"Wood/plastics",null,"2008-01-03"]

{"sheet":"Bungee","index":32,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Resonant Frequency of Suspended Mass on a Spring"]
[]
[null,null,"The spring is assumed linear and without mass."]
[]
[null,null,"Spring deflection in inches",null,null,null,1,"in"]
[null,null,"Resonant frequency will be",null,null,null,{"$f":"(1/(2*PI()))*SQRT(9.81/(G5*0.0254))","v":3.1277913699054261},"Hz"]

{"sheet":"Compression- Round Wire","index":33,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Helical Compression Spring Designer",null,null,null,null,null,null,null,null,"Formulas from Machinery's Handbook, Shigley & Mischke, et al."]
[]
[" ","Spring name here"]
[null,"Spring OD",null,null,7.5,"mm",{"$f":"E4/25.4","v":0.29527559055118113},"in",null,"mean diameter",null,{"$f":"E4-E5","v":6.75},"mm"]
[null,"Wire diameter",null,null,0.75,"mm",{"$f":"E5/25.4","v":2.9527559055118113E-2},"in",null,"ID",null,{"$f":"E4-E5-E5","v":6},"mm",{"$f":"L5/25.4","v":0.23622047244094491},"in"]
[null,"Number of active coils",null,null,11.5,null,null,null,null,"Inactive coils",null,3]
[null,"Winding pitch",null,null,2.5,"mm",{"$f":"E7/25.4","v":9.8425196850393706E-2},"in"]
[null,"Modulus of rigidity, G",null,null,79300,"MPa",{"$f":"145.0377*E8","v":11501489.609999999},"psi",null,"Young's modulus, E",null,207000,"Mpa",null,"Poisson's ratio, v",null,0.30499999999999999]
[null,"Tensile strength",null,null,1700,"MPa",{"$f":"145.0377*E9","v":246564.09},"psi",null,"G, from above",null,{"$f":"L8/(2*(1+Q8))","v":79310.344827586217},"Mpa"]
[]
[null,"k",null,null,{"$f":"(E8*E5^4)/(8*L4^3*E6)","v":0.88678654499910536},"N/mm",{"$f":"E11*101.9716","v":90.427042852030766},"grams/mm"]
[null,"Force at solid",null,null,{"$f":"(E22-E21)*E11","v":17.846579218106996},"N ",{"$f":"E12*101.9716","v":1819.8442373971193},"grams"]
[null,"Spring index (5-9 typ, 15 max)",null,null,{"$f":"(E4-E5)/E5","v":9}]
[null,"Stress factor, Kw1",null,null,{"$f":"((4*E13-1)/(4*E13-4))+(0.615/E13)","v":1.1620833333333334}]
[null,"Stress factor, Kw2",null,null,{"$f":"1+(0.5/E13)","v":1.0555555555555556}]
[null,"Stress at solid",null,null,{"$f":"(8*E15*E12*L4)/(PI()*E5^3)","v":767.53144457974895},"MPa",{"$f":"145.0377*E16","v":111320.99539952425},"psi"]
[null,"Percentage of max stress",null,null,{"$f":"E16/E9","v":0.45148908504691115}]
[]
[null,"Ratio of pitch to mean diameter",null,null,{"$f":"E7/L4","v":0.37037037037037035}]
[]
[null,"Solid length",null,null,{"$f":"(E6+L6)*E5","v":10.875},"mm",{"$f":"E21/25.4","v":0.42814960629921262},"in",null,"Inactive coils are added here"]
[null,"Free length",null,null,{"$f":"(E6*E7)+(L6*E5)","v":31},"mm",{"$f":"E22/25.4","v":1.2204724409448819},"in",null,"and here"]
[]
[null,"Force at three compressions:"]
[null,"Comp 1",25.4,"mm",{"$f":"(E22-C25)*G11","v":506.39143997137239},"grams","check if > solid length and < free length",null,null,null,{"$f":"E25/453.592","v":1.116402934732915},"lbs"]
[null,"Comp 2",3,"mm",{"$f":"(E22-C26)*G11","v":2531.9571998568613},"grams","check if > solid length and < free length",null,null,null,{"$f":"E26/453.592","v":5.5820146736645739},"lbs"]
[null,"Comp 3",{"$f":"NA()","v":{"$error":"#N/A"}},"mm",{"$f":"(E22-C27)*G11","v":{"$error":"#N/A"}},"grams",null,null,null,null,{"$error":"#N/A"},"lbs"]
[]
[null,"Resonant frequency",null,null,{"$f":"(3.5*10^5*E5)/(L4^2*E6)","v":500.98407586330291},"Hz"]
[null,null,null,null,null,null,null,null,null,"Material Properties for Springs"]
[null,null,null,null,null,null,null,null,null,null,null,"E","G","TS","Poisson's"]
[null,null,null,null,null,null,null,null,null,"Music wire",null,207000,79300,1700,0.30499999999999999]
[null,null,null,null,null,null,null,null,null,"C17200 BeCu",null,"125000",48300,"1030",0.28499999999999998]
[null,null,null,null,null,null,null,null,null,"Stainless, 302/304",null,"193000","69000","862","0.29"]
[null,null,null,null,null,null,null,null,null,"Fused Quartz",null,"720000","31000","48*","0.17"]
[null,null,null,null,null,null,null,null,null,"Phos bronze, 510",null,"103000","43100","724","0.341"]

{"sheet":"Compression- Rectangular Wire","index":34,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Helical Compression Spring Designer (Rectangular Wire)",null,null,null,null,null,null,null,null,"Formulas from Machinery's Handbook, Shigley & Mischke, et al."]
[]
[null,"Spring OD",null,null,10,"mm",{"$f":"E3/25.4","v":0.39370078740157483},"in",null,"mean diameter",null,{"$f":"E3-E6","v":8.5},"mm"]
[null,"Spring ID",null,null,7,"mm",{"$f":"E4/25.4","v":0.27559055118110237},"in"]
[null,"Wire thickness (axial-b)",null,null,0.25,"mm",{"$f":"E5/25.4","v":9.8425196850393699E-3},"in",null,"Warning- this must be smaller than the next line!"]
[null,"Wire width (radial-t)",null,null,{"$f":"(E3-E4)/2","v":1.5},"mm",{"$f":"E6/25.4","v":5.9055118110236227E-2},"in"]
[null,"Number of active coils",null,null,20]
[null,"Winding pitch",null,null,0.7,"mm",{"$f":"E8/25.4","v":2.7559055118110236E-2},"in",null,"worksheet assumes total of 3 inactive coils, 1.5 each end."]
[null,"Modulus (79300 for music wire)",null,null,79300,"Mpa",null,null,null,"C17200 (Be Cu) is about 48300 (mine is .0055\", too heavy)"]
[]
[null,"Torsion Constants for Rectangular Bar (this table not presently used but included for future additions)"]
[null,"b/c ratio",1,1.2,1.5,1.75,2,2.5,3,4,5,6,8,10,"inf"]
[null,"alpha 1",0.20799999999999999,0.219,0.23100000000000001,0.23899999999999999,0.246,0.25800000000000001,0.26700000000000002,0.28199999999999997,0.29099999999999998,0.29899999999999999,0.307,0.312,0.33300000000000002]
[null,"alpha 2",0.20799999999999999,0.23499999999999999,0.26900000000000002,0.29099999999999998,0.309,0.33600000000000002,0.35499999999999998,0.378,0.39200000000000002,0.40200000000000002,0.41399999999999998,0.42099999999999999]
[null,"beta",0.1406,0.16600000000000001,0.19600000000000001,0.214,0.22900000000000001,0.249,0.26300000000000001,0.28100000000000003,0.29099999999999998,0.29899999999999999,0.307,0.312,0.33300000000000002]
[]
[null,"Shape Factor Table"]
[null,"b/t",1,null,1.5,1.75,2,2.5,3,4,null,6,8,10]
[null,"K1",2.41,null,2.16,2.09,2.04,1.94,1.87,1.77,null,1.67,1.63,1.6]
[null,"K2",0.18,null,0.25,0.27200000000000002,0.29199999999999998,0.317,0.33500000000000002,0.38500000000000001,null,0.38100000000000001,0.39100000000000001,0.39900000000000002]
[]
[null,"Actual b/t ratio",null,null,{"$f":"E6/E5","v":6}]
[null,"Select K1 from table",null,null,1.67]
[null,"Select K2 from table",null,null,0.38100000000000001]
[]
[null,"k",null,null,{"$f":"(E24*E9*E6*E5^3)/(E7*L3^3)","v":5.7653101465499693E-2},"N/mm",{"$f":"E26*101.9716","v":5.8789790013993484},"grams/mm"]
[null,"Force at solid",null,null,{"$f":"(E33-E32)*E26","v":0.51887791318949728},"N ",{"$f":"E27*101.9716","v":52.910811012594138},"grams",null,"(not sure what happens when a machined spring goes \"solid\" but might not be good)"]
[null,"Spring index (5-9 typ, 15 max)",null,null,{"$f":"L3/E6","v":5.666666666666667}]
[null,"Stress factor",null,null,{"$f":"1+(0.5/E28)","v":1.088235294117647},null,null,null,null,"(need a new formula for this- don't use)"]
[null,"Stress at solid (<10000 typ)",null,null,{"$f":"(8*E29*E27*L3)/(PI()*E5^3)","v":782.21655950763159},null,null,null,null,"(this is no longer valid- fix or ignore)"]
[]
[null,"Solid length",null,null,{"$f":"(E7+3)*E5","v":5.75},"mm",{"$f":"E32/25.4","v":0.22637795275590553},"in"]
[null,"Free length",null,null,{"$f":"(E7*E8)+(3*E5)","v":14.75},"mm",{"$f":"E33/25.4","v":0.58070866141732291},"in"]
[]
[]
[null,"Force at two compressions:"]
[null,"Comp 1",5.75,"mm",{"$f":"(E33-C37)*G26","v":52.910811012594138},"grams","check if ok for solid length"]
[null,"Comp 2",7.8,"mm",{"$f":"(E33-C38)*G26","v":40.858904059725475},"grams","check if ok for free length"]

{"sheet":"Extension","index":35,"n_rows":76,"n_cols":18,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["Helical Extension Spring Designer",null,null,null,null,"Formulas from Machinery's Handbook, Shigley & Mischke, et al."]
[]
[]
[]
[]
[]
[]
[]
[null,"M3-LS-3.4 Spring",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"convert-"]
[null,"Spring OD",null,null,1.9810000000000001,"mm",{"$f":"E10/25.4","v":7.7992125984251981E-2},"in",null,"Mean diameter",null,{"$f":"E10-E11","v":1.8032000000000001},"mm",{"$f":"L10/25.4","v":7.0992125984251975E-2},"in",null,"psi","MPa"]
[null,"Wire OD",null,null,0.17780000000000001,"mm",{"$f":"E11/25.4","v":7.000000000000001E-3},"in",null,"ID",null,{"$f":"E10-E11-E11","v":1.6254000000000002},"mm",{"$f":"L11/25.4","v":6.3992125984251982E-2},"in",null,399000,{"$f":"Q11/145.037738","v":2751.0081548569106}]
[null,"Number of active coils",null,null,50]
[null,"Length of active coils",null,null,{"$f":"E11*(E12+1)","v":9.0678000000000001},"mm",{"$f":"E13/25.4","v":0.35700000000000004},"in"]
[]
[null,"Modulus of Rigidity (Shear)",null,null,69000,"MPa",{"$f":"E15*145.037738","v":10007603.922},"psi",null,"Materials","music wire","302/304 SS","17-7 SS","C17200","316 SS","other","other"]
[null,"Tensile strength",null,null,2200,"MPa",{"$f":"E16*145.037738","v":319083.02359999996},"psi",null,"Modulus of Rigidity",79300,69000,75800,48300,69000]
[null,null,null,null,null,null,null,null,null,"Tensile Strength",2700,2200,2300,1500,1520]
[null,"k",null,null,{"$f":"(E15*E11^4)/(8*L10^3*E12)","v":2.9402511590204367E-2},"N/mm",{"$f":"E18*101.9716","v":2.9982211508716836},"grams/mm",null,"Max in bending",0.75,0.75,0.75,0.75,0.75]
[null,null,null,null,null,null,null,null,null,"Max in torsion",0.45,0.4,0.45,0.4,0.4]
[null,"Initial tension stress target",null,null,{"$f":"231/(10^(0.0456*E23))","v":79.643252531768056},"Mpa",{"$f":"E20*145.037738","v":11551.27719417041},"psi",null,"Insert values"]
[null,"Initial tension from above",null,null,{"$f":"(PI()*E20*E11^3)/(8*L10)","v":9.7490039121889582E-2},"N ",{"$f":"E21*101.9716","v":9.9412152733216761},"grams"]
[null,"Initial tension actual",null,null,{"$f":"G22/101.9716","v":9.8066520482173472E-2},"N ",10,"grams"]
[null,"Spring index",null,null,{"$f":"(E10-E11)/E11","v":10.141732283464567}]
[null,"Wahl correction factor",null,null,{"$f":"((4*E23-1)/(4*E23-4))+(0.615/E23)","v":1.1426818716195613}]
[]
[null,"Free length, c-c",null,null,{"$f":"E13+(E10/2)+(E10/2)","v":11.048800000000002},"mm",{"$f":"E26/25.4","v":0.43499212598425208},"in"]
[null,"Free length, inside ends",null,null,{"$f":"E26+(L11/2)+(L11/2)","v":12.674200000000001},"mm",{"$f":"E27/25.4","v":0.49898425196850399},"in"]
[]
[null,"Force at two center-to-center distances:"]
[null,"c-c 1",0,"mm",{"$f":"(E18*(C30-E26))+E22","v":-0.22679594957567661},"N",{"$f":"E30*101.9716","v":-23.126745851751064},"grams"]
[null,"c-c 2",0,"mm",{"$f":"(E18*(C31-E26))+E22","v":-0.22679594957567661},"N",{"$f":"E31*101.9716","v":-23.126745851751064},"grams"]
[]
[null,"Force at two inside contact distances of loops:"]
[null,1,22.5,"mm",{"$f":"(E18*(C34-E27))+E22","v":0.38696971886520348},"N",{"$f":"E34*101.9716","v":39.459921384234981},"grams"]
[null,2,37.5,"mm",{"$f":"(E18*(C35-E27))+E22","v":0.82800739271826906},"N",{"$f":"E35*101.9716","v":84.433238647310247},"grams"]
[]
[null,"Stress at contact distance 2",null,null,{"$f":"(8*E35*L10*E24)/(PI()*E11^3)","v":772.94447087334925},"MPa",{"$f":"E37*145.037738","v":112106.11765507745},"psi"]
[null,"Percentage of max stress",null,null,{"$f":"E37/E16","v":0.35133839585152238},null,{"$f":"G37/G16","v":0.35133839585152243},null,null,"Should not exceed:",0.4]
[]
[null,"Force at two deflections from solid:"]
[null,"Def 1",0,"mm",{"$f":"(E18*C41)+E22","v":9.8066520482173472E-2},"N",{"$f":"E41*101.9716","v":10},"grams"]
[null,"Def 2",0,"mm",{"$f":"(E18*C42)+E22","v":9.8066520482173472E-2},"N",{"$f":"E42*101.9716","v":10},"grams"]
[]
[null,"Stress at Def 2",null,null,{"$f":"(8*E42*L10*E24)/(PI()*E11^3)","v":91.545045915157814},"MPa",{"$f":"E44*145.037738","v":13277.486384640628},"psi"]
[null,"Percentage of max stress",null,null,{"$f":"E44/E16","v":4.1611384506889913E-2},null,{"$f":"G44/G16","v":4.161138450688992E-2},null,null,"Should not exceed:",0.4]
[]
[null,"Resonant frequency",null,null,{"$f":"(176000*E11)/(L10^2*E12)","v":192.48044883629927},"Hz",{"$f":"1000/E47","v":5.1953328561202587},"mS"]
[]
[null,"Hook/Loop Stress"]
[]
[null,"Radius of first bend off coil, R2",null,null,0.4,"mm",{"$f":"E51/25.4","v":1.5748031496062995E-2},"in"]
[null,"C2",null,null,{"$f":"(2*E51)/E11","v":4.4994375703037122},null,{"$f":"(2*G51)/G11","v":4.4994375703037122}]
[null,"Kb",null,null,{"$f":"(4*E52-1)/(4*E52-4)","v":1.2143201542912248},null,{"$f":"(4*G52-1)/(4*G52-4)","v":1.2143201542912248}]
[null,"Torsion stress at B",null,null,{"$f":"E53*((8*E35*L10)/(PI()*E11^3))","v":821.40276523260354},"Mpa",{"$f":"E54*145.037738","v":119134.39905628185},"psi"]
[null,"Percentage of max stress",null,null,{"$f":"E54/E16","v":0.37336489328754707},null,{"$f":"G54/G16","v":0.37336489328754707},null,null,"Should not exceed:",0.4]
[]
[null,"Radius of hook, R1",null,null,0.9,"mm",{"$f":"E57/25.4","v":3.5433070866141732E-2},"in"]
[null,"C1",null,null,{"$f":"(2*E57)/E11","v":10.123734533183352},null,{"$f":"(2*G57)/G11","v":10.123734533183351}]
[null,"Ka",null,null,{"$f":"(4*E58^2-E58-1)/(4*E58*(E58-1))","v":1.0794965650214388},null,{"$f":"(4*G58^2-G58-1)/(4*G58*(G58-1))","v":1.0794965650214388}]
[null,"Bending stress at A",null,null,{"$f":"E35*(E59*((16*L10)/(PI()*E11^3))+(4/(PI()*E11^2)))","v":1493.7568955167551},"Mpa",{"$f":"E60*145.037738","v":216651.12124765248},"psi"]
[null,"Percentage of max stress",null,null,{"$f":"E60/E16","v":0.6789804070530705},null,{"$f":"G60/G16","v":0.6789804070530705},null,null,"Should not exceed:",0.75]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Arbor Selection for Winding"]
[]
[null,"Start with",null,{"$f":"$L$10-(2*$E$11)","v":1.4476},"mm",{"$f":"D75/25.4","v":5.6992125984251969E-2},"in"]
[null,"Will typically be a bit smaller for high index springs."]

{"sheet":"Torsion","index":36,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Torsion Spring Designer"]
[]
[null,"Spring OD",null,null,3.5,"mm",{"$f":"E3/25.4","v":0.13779527559055119},"in",null,"mean diameter",null,{"$f":"E3-E4","v":3.246},"mm"]
[null,"Wire diameter",null,null,0.254,"mm",{"$f":"E4/25.4","v":0.01},"in",null,"ID",null,{"$f":"E3-E4-E4","v":2.992},"mm",{"$f":"L4/25.4","v":0.11779527559055118},"in"]
[null,"Body coils",null,null,3]
[null,"End length 1",null,null,6,"mm",{"$f":"E6/25.4","v":0.23622047244094491}]
[null,"End length 2",null,null,6,"mm",{"$f":"E7/25.4","v":0.23622047244094491}]
[null,"Total coils",null,null,{"$f":"E5+((E6+E7)/(3*PI()*E3))","v":3.3637827270671892}]
[null,"Modulus (79300 for music wire)",null,null,79300,"Mpa",null,null,null,"C17200 (Be Cu) is about 48300 (mine is .0055\")"]
[]
[null,"k (moment/turn)",null,null,{"$f":"(E9*E4^4)/(10.8*L3*E8)","v":2.7990318910390091},"N * mm"]
[null,"turns",null,null,0.25]
[null,"force",null,null,{"$f":"(E11*E12)/E6","v":0.11662632879329204},"N"]
[null,null,null,null,{"$f":"E13*101.9716","v":11.892573349178058},"grams"]

{"sheet":"Wave Washers","index":37,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Wave Washer Calculator"]
[]
[null,"OD, D",null,null,null,{"$f":"I3*25.4","v":26.974799999999998},"mm",null,1.0620000000000001,"in"]
[null,"ID, d",null,null,null,{"$f":"I4*25.4","v":19.1008},"mm",null,0.752,"in"]
[null,"average diameter, Dm",null,null,null,23.037800000000001,"mm",null,{"$f":"(I3+I4)/2","v":0.90700000000000003},"in"]
[null,"rim width, b",null,null,null,3.9370000000000003,"mm",null,{"$f":"(I3-I4)/2","v":0.15500000000000003},"in"]
[null,"number of waves, N",null,null,null,3]
[null,"modulus of elasticity, E",null,null,null,206000,"N/mm²"]
[null,"thickness, t",null,null,null,{"$f":"I9*25.4","v":0.38099999999999995},"mm",null,1.4999999999999999E-2,"in"]
[null,"deflection, δ",null,null,null,0.254,"mm",null,0.01,"in"]
[null,"load, P",null,null,null,{"$f":"(16*F8*F6*F9^3*F7^4*F10)/(PI()^3*F5^3)","v":38.946967773995205},"N ",null,{"$f":"0.2248089*F11","v":8.7556249836073103},"lbf"]
[null,"Stress, S",null,null,null,{"$f":"(0.75*PI()*F11*F5)/(F6*F9^2*F7^2)","v":411.02469467684222},"N/mm²",null,{"$f":"145.03773800722*F12","v":59614.09198103744},"psi"]
[null,"k",null,null,null,{"$f":"F11/F10","v":153.33451879525671},"N/mm ",null,{"$f":"F13/0.17513","v":875.5468440316148},"lbf/in"]

{"sheet":"Flats","index":38,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Optical Flat Measurements in the Shop"]
[]
[null,"Lamp wavelength",null,null,null,5.4610000000000005E-7,"m","(the Unilamp is 5461 angstroms or 546.1 nm)"]
[]
[null,"# of fringes seen",null,null,null,0.5]
[]
[null,"height variation",null,null,null,{"$f":"0.5*F3*F5","v":1.3652500000000001E-7},"m"]
[null,null,null,null,null,{"$f":"F7*1000000","v":0.13652500000000001},"um","hard to resolve better than 1/2 fringe, so 0.14 um is about the limit"]
[null,null,null,null,null,{"$f":"F7*39.37","v":5.37498925E-6},"in"]
[]
[]
["Lapping plate flatness measurements with indicator gauge and test bar"]
[]
[null,"Gauge contact point distance",null,null,null,11,"in"]
[null,"Indicator distance from edge",null,null,null,3.75,"in"]
[null,"Reading (+ or -)",null,null,null,5.0000000000000002E-5,"in","Mostly you will enter this number- best gage reads in increments of 0.00005\""]
[]
[null,"X1",0,"Y1",1,null,"left-most point of gauge arbitrairly set to 0,1 to avoid divide by zero error"]
[null,"X2",{"$f":"F15","v":3.75},"Y2",{"$f":"F16+E18","v":1.0000500000000001},null,"dial indicator is x inches in and y is the reading, corrected for above offset of 1"]
[null,"X3",{"$f":"F14","v":11},"Y3",{"$f":"E18","v":1},null,"right-most point of gauge is in the same plane as the first and x inches away"]
[]
[null,"A",{"$f":"C18*(E19-E20)-E18*(C19-C20)+C19*E20-C20*E19","v":-5.5000000000049454E-4}]
[null,"B",{"$f":"(C18^2+E18^2)*(E20-E19)+(C19^2+E19^2)*(E18-E20)+(C20^2+E20^2)*(E19-E18)","v":6.0500000000127674E-3}]
[null,"C",{"$f":"(C18^2+E18^2)*(C19-C20)+(C19^2+E19^2)*(C20-C18)+(C20^2+E20^2)*(C18-C19)","v":-299.0613999725}]
[null,"D",{"$f":"(C18^2+E18^2)*(C20*E19-C19*E20)+(C19^2+E19^2)*(C18*E20-C20*E18)+(C20^2+E20^2)*(C19*E18-C18*E19)","v":299.06194997249997}]
[]
[null,"center of circle"]
[null,"x",{"$f":"-C23/(2*C22)","v":5.5000000000066613},"y",{"$f":"-C24/(2*C22)","v":-271873.99997475551}]
[]
[null,"radius of circle"]
[null,"r ",{"$f":"SQRT((C23^2+C24^2-4*C22*C25)/(4*C22^2))","v":271875.00003038772},"in"]
[null,null,{"$f":"C31/12","v":22656.25000253231},"feet"]
[null,null,{"$f":"C31/12/5280","v":4.2909564398735434},"miles",null,"this is just to put things into perspective when you complain it isn't flat enough."]
[]
[]
["Parallelism- not a function of the planetary lapping machine, but commonly needed and measured with the autocollimator"]
[]
[null,"Error",0.5,"minutes",null,"autocollimator range is plus and minus 15 minutes of angle"]
[null,"Baseline",20,"mm"]
[null,"Error",{"$f":"C38/60","v":8.3333333333333332E-3},"deg",null,"interestingly, the autocollimator is about 10X the accuracy of the Keyence 3-laser system"]
[null,"Height",{"$f":"TAN(RADIANS(C38/60))*C39*1000","v":2.9088821071687012},"um"]
[null,"Height",{"$f":"C41/25400","v":1.1452291760506698E-4},"in"]
[]
[null,"Or, going the other way"]
[]
[null,"Error",1.15E-4,"in",null,"error at the edge of the baseline, usually measured with a mic"]
[null,"Error",{"$f":"C46*25400","v":2.9210000000000003},"um"]
[null,"Baseline",20,"mm"]
[null,"Angle",{"$f":"90-DEGREES(ATAN(C48/C47*1000))","v":8.3680485383723635E-3},"deg"]
[null,"Angle",{"$f":"C49*60","v":0.50208291230234181},"minutes"]

{"sheet":"Drop Tests","index":39,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Drop Testing"]
[null,null,null,null,null,null,null,null,null,null,"gravity",null,32.159999999999997,"ft/sec^2","fps"]
[null,null,null,"fps",null,null,"cgs",null,null,null,"gravity",null,980.66499999999996,"cm/sec^2","cgs"]
[null,"Drop height",null,2,"ft",null,{"$f":"D4*12*2.54","v":60.96},"cm"]
[null,"Mass",null,{"$f":"G5/453.59237","v":0.11023113109243879},"pounds",null,50,"grams",null,null,"1 pound of force = 32 poundals"]
[null,"Time of flight",null,{"$f":"SQRT((2*D4)/M2)","v":0.35267280792929917},"sec",null,{"$f":"SQRT((2*G4)/M3)","v":0.35259580355737219},"sec",null,null,"1 gram of force = 980 dynes"]
[null,"Velocity on impact",null,{"$f":"SQRT(2*M2*D4)","v":11.34195750300626},"ft/sec",null,{"$f":"SQRT(2*M3*G4)","v":345.77836369559043},"cm/sec",null,null,"1 dyne-cm = 1 erg"]
[null,"Velocity on impact",null,{"$f":"D7*12","v":136.10349003607513},"in/sec",null,{"$f":"G7/100","v":3.4577836369559041},"m/sec"]
[null,"Energy on impact",null,{"$f":"(D5*D7^2)/2","v":7.0900663518656621},"ft-pdl",null,{"$f":"(G5*G7^2)/2","v":2989066.9200000004},"dyne-cm"]
[null,"Energy on impact",null,{"$f":"(D5*D7^2)/(2*M2)","v":0.22046226218487758},"ft-lb",null,{"$f":"(G5*G7^2)/(2*M3)","v":3048.0000000000005},"gram-cm"]
[]
[null,"Decel distance",null,9.6000000000000002E-2,"in",null,{"$f":"D12*2.54","v":0.24384},"cm"]
[null,"Decel distance",null,{"$f":"D12/12","v":8.0000000000000002E-3},"ft"]
[null,"Decel  ",null,{"$f":"D7^2/(2*D13)","v":8039.9999999999991},"ft/sec^2",null,{"$f":"G7^2/(2*G12)","v":245166.25000000003},"cm/sec^2"]
[null,"g value",null,{"$f":"D14/M2","v":250},null,null,{"$f":"G14/M3","v":250.00000000000003}]
[]
[null,"force on impact",null,{"$f":"D5*D14","v":886.25829398320775},"pdl",null,{"$f":"G5*G14","v":12258312.500000002},"dynes"]
[null,"force on impact",null,{"$f":"D17/M2","v":27.557782773109697},"pounds",null,{"$f":"G17/M3/1000","v":12.500000000000002},"kg"]
[]
[null,"You can bypass the standard formulas since the target g force and the drop height in inches are known. 5/3500=.0014 (the decel distance)."]
[null,"3500*.249=871 (the force on impact)"]

{"sheet":"TT Counterweights","index":40,"n_rows":86,"n_cols":12,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["Counterweights"]
[null,null,"in","m","cm","mm"]
[null,"OD",0.49,{"$f":"C3*0.0254","v":1.2445999999999999E-2},{"$f":"C3*2.54","v":1.2445999999999999},{"$f":"C3*25.4","v":12.446},null,null,null,"material","density"]
[null,"ID",0.115,{"$f":"C4*0.0254","v":2.921E-3},{"$f":"C4*2.54","v":0.29210000000000003},{"$f":"C4*25.4","v":2.9209999999999998}]
[null,"T",0.26,{"$f":"C5*0.0254","v":6.6039999999999996E-3},{"$f":"C5*2.54","v":0.66039999999999999},{"$f":"C5*25.4","v":6.6040000000000001},null,null,null,"aluminum",2720]
[null,null,null,null,null,null,null,null,null,"steel",7850]
[null,"Outer volume",{"$f":"C5*PI()*(C3/2)^2","v":4.9029265748249104E-2},{"$f":"D5*PI()*(D3/2)^2","v":8.0344571568956574E-7},{"$f":"E5*PI()*(E3/2)^2","v":0.80344571568956602},{"$f":"F5*PI()*(F3/2)^2","v":803.44571568956599},null,null,null,"brass",8460]
[null,"Inner volume",{"$f":"C5*PI()*(C4/2)^2","v":2.7005915848421261E-3},{"$f":"D5*PI()*(D4/2)^2","v":4.4254767138669342E-8},{"$f":"E5*PI()*(E4/2)^2","v":4.4254767138669354E-2},{"$f":"F5*PI()*(F4/2)^2","v":44.254767138669344},null,null,null,"bronze, 544",8810]
[null,"Total volume",{"$f":"C7-C8","v":4.6328674163406976E-2},{"$f":"D7-D8","v":7.5919094855089642E-7},{"$f":"E7-E8","v":0.75919094855089664},{"$f":"F7-F8","v":759.19094855089668},null,null,null,"magnesium",1738]
[null,null,null,null,null,null,null,null,null,"Delrin",1183]
[null,null,"lbs/ft^3","kg/m^3","g/cm^3",null,null,null,null,"lead",11340]
[null,"material density",{"$f":"D12*0.062427965","v":549.99037165000004},8810,{"$f":"D12/1000","v":8.81},null,null,null,null,"copper",8940]
[null,null,null,null,null,null,null,null,null,"gold",19320]
[null,null,"lbs","kg","g",null,null,null,null,"mercury",13593]
[null,"mass",{"$f":"D15*2.20462","v":1.4745539706639582E-2},{"$f":"D9*D12","v":6.6884722567333976E-3},{"$f":"D15*1000","v":6.6884722567333972},null,null,null,null,"nickel",8908]
[null,null,null,null,null,null,null,null,null,"silver",10490]
[null,null,"in","m","cm","mm",null,null,null,"tungsten",19300]
[null,"Distance to beam",0.69699999999999995,{"$f":"C18*0.0254","v":1.7703799999999999E-2},{"$f":"C18*2.54","v":1.7703799999999998},{"$f":"C18*25.4","v":17.703799999999998},null,null,null,"sapphire",3980]
[]
[null,null,"in-lbs",null,"gm-cm",null,"mN-m","uN-m"]
[null,"Torque @ 90 horiz",{"$f":"C18*C15","v":1.0277641175527787E-2},null,{"$f":"E15*E18","v":11.841137513875671},null,{"$f":"E21*0.0980665","v":1.1612189120044885},{"$f":"G21*1000","v":1161.2189120044884}]
[]
[null,"Enter angle",45,"degrees"]
[]
[null,"Sine",{"$f":"SIN(RADIANS(C23))","v":0.70710678118654746}]
[null,null,null,null,null,null,"mN-m","uN-m"]
[null,"Torque",{"$f":"C21*C25","v":7.2673897698177772E-3},null,{"$f":"E21*C25","v":8.3729486330239027},null,{"$f":"G21*C25","v":0.82110576712043848},{"$f":"H21*C25","v":821.10576712043849}]
[]
[]
[]
["Platters (Flywheels), counterweights & general cylinder mass problems"]
[]
[null,null,"in","m","cm","mm"]
[null,"OD",1.75,{"$f":"C34*0.0254","v":4.4449999999999996E-2},{"$f":"C34*2.54","v":4.4450000000000003},{"$f":"C34*25.4","v":44.449999999999996}]
[null,"ID",0.9375,{"$f":"C35*0.0254","v":2.38125E-2},{"$f":"C35*2.54","v":2.3812500000000001},{"$f":"C35*25.4","v":23.8125}]
[null,"T",0.75,{"$f":"C36*0.0254","v":1.9049999999999997E-2},{"$f":"C36*2.54","v":1.905},{"$f":"C36*25.4","v":19.049999999999997}]
[]
[null,"Outer volume",{"$f":"C36*PI()*(C34/2)^2","v":1.8039614065535141},{"$f":"D36*PI()*(D34/2)^2","v":2.9561631022722448E-5},{"$f":"E36*PI()*(E34/2)^2","v":29.561631022722459},{"$f":"F36*PI()*(F34/2)^2","v":29561.631022722442}]
[null,"Inner volume",{"$f":"C36*PI()*(C35/2)^2","v":0.51771851591140394},{"$f":"D36*PI()*(D35/2)^2","v":8.4838864542251943E-6},{"$f":"E36*PI()*(E35/2)^2","v":8.4838864542251944},{"$f":"F36*PI()*(F35/2)^2","v":8483.8864542251922}]
[null,"Total volume",{"$f":"C38-C39","v":1.2862428906421102},{"$f":"D38-D39","v":2.1077744568497252E-5},{"$f":"E38-E39","v":21.077744568497266},{"$f":"F38-F39","v":21077.744568497248}]
[]
[null,null,"lbs/ft^3","kg/m^3","g/cm^3"]
[null,"material density",{"$f":"D43*0.062427965","v":169.80406479999999},2720,{"$f":"D43/1000","v":2.72}]
[null,null,null,null,null,null,null,null,null,"M3-F Target"]
[null,null,"lbs","kg","g"]
[null,"mass",{"$f":"D46*2.20462","v":0.1263940948672331},{"$f":"D43*D40","v":5.7331465226312522E-2},{"$f":"D46*1000","v":57.331465226312524},null,null,null,null,"top ring",4.7039999999999997,"g"]
[null,null,null,null,null,null,null,null,null,"threaded end",1.244,"g"]
[null,"Speed",33.333300000000001,"RPM",{"$f":"C48/60","v":0.55555500000000002},"RPS",{"$f":"1/E48","v":1.8000018000017999},"SPR",null,"total mass",{"$f":"K46+K47","v":5.9479999999999995},"g"]
[null,"w",{"$f":"2*PI()*E48","v":3.490655013330155},"rad/S",null,null,null,null,null,"target",5,"g"]
[null,null,null,null,null,null,null,null,null,"remove",{"$f":"K48-K49","v":0.94799999999999951},"g"]
[null,"Moment of inertia",{"$f":"0.5*D46*((D34/2)^2 + (D35/2)^2)","v":1.822307608318186E-5},"kg-m^2"]
[]
[null,"Stored energy",{"$f":"0.5*C51*C49^2","v":1.1102110629816909E-4},"J"]
[]
[]
[]
[]
[]
[]
[]
["Anti-Skate Weights (cylinders with hole and counterbore)"]
[]
[null,null,"in","m","cm","mm"]
[null,"OD",0.34499999999999997,{"$f":"C64*0.0254","v":8.7629999999999982E-3},{"$f":"C64*2.54","v":0.87629999999999997},{"$f":"C64*25.4","v":8.7629999999999981}]
[null,"ID",0.161,{"$f":"C65*0.0254","v":4.0894E-3},{"$f":"C65*2.54","v":0.40894000000000003},{"$f":"C65*25.4","v":4.0893999999999995}]
[null,"T",0.33800000000000002,{"$f":"C66*0.0254","v":8.5851999999999994E-3},{"$f":"C66*2.54","v":0.85852000000000006},{"$f":"C66*25.4","v":8.5852000000000004}]
[]
[null,"Outer volume",{"$f":"C66*PI()*(C64/2)^2","v":3.1596921542652874E-2},{"$f":"D66*PI()*(D64/2)^2","v":5.1778077552243116E-7},{"$f":"E66*PI()*(E64/2)^2","v":0.5177807755224314},{"$f":"F66*PI()*(F64/2)^2","v":517.7807755224311}]
[null,"Inner volume",{"$f":"C66*PI()*(C65/2)^2","v":6.8811073581777384E-3},{"$f":"D66*PI()*(D65/2)^2","v":1.127611466693295E-7},{"$f":"E66*PI()*(E65/2)^2","v":0.11276114666932953},{"$f":"F66*PI()*(F65/2)^2","v":112.76114666932948}]
[null,"Total volume 1",{"$f":"C68-C69","v":2.4715814184475136E-2},{"$f":"D68-D69","v":4.0501962885310166E-7},{"$f":"E68-E69","v":0.40501962885310189},{"$f":"F68-F69","v":405.01962885310161}]
[]
[null,"C-Bore diameter",0,{"$f":"C72*0.0254","v":0},{"$f":"C72*2.54","v":0},{"$f":"C72*25.4","v":0}]
[null,"Phantom ID",{"$f":"C65","v":0.161},{"$f":"C73*0.0254","v":4.0894E-3},{"$f":"C73*2.54","v":0.40894000000000003},{"$f":"C73*25.4","v":4.0893999999999995}]
[null,"C-Bore depth",0,{"$f":"C74*0.0254","v":0},{"$f":"C74*2.54","v":0},{"$f":"C74*25.4","v":0}]
[]
[null,"Outer volume",{"$f":"C74*PI()*(C72/2)^2","v":0},{"$f":"D74*PI()*(D72/2)^2","v":0},{"$f":"E74*PI()*(E72/2)^2","v":0},{"$f":"F74*PI()*(F72/2)^2","v":0}]
[null,"Inner volume",{"$f":"C74*PI()*(C73/2)^2","v":0},{"$f":"D74*PI()*(D73/2)^2","v":0},{"$f":"E74*PI()*(E73/2)^2","v":0},{"$f":"F74*PI()*(F73/2)^2","v":0}]
[null,"Total volume 2",{"$f":"C76-C77","v":0},{"$f":"D76-D77","v":0},{"$f":"E76-E77","v":0},{"$f":"F76-F77","v":0}]
[]
[null,"Total volume",{"$f":"C70-C78","v":2.4715814184475136E-2},{"$f":"D70-D78","v":4.0501962885310166E-7},{"$f":"E70-E78","v":0.40501962885310189},{"$f":"F70-F78","v":405.01962885310161}]
[]
[null,null,"lbs/ft^3","kg/m^3","g/cm^3"]
[null,"material density",{"$f":"D83*0.062427965","v":530.63770250000005},8500,{"$f":"D83/1000","v":8.5}]
[]
[null,null,"lbs","kg","g"]
[null,"mass",{"$f":"D86*2.20462","v":7.5897721803780622E-3},{"$f":"D83*D80","v":3.4426668452513642E-3},{"$f":"D86*1000","v":3.442666845251364}]

{"sheet":"Barometric Pressure","index":41,"n_rows":34,"n_cols":19,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Barometric Pressure",null,null,null,null,"Entries in blue, results in red."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pressure, in","Corrected, mb"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30.2,{"$f":"(R7*33.86389)*EXP(-$K$17/($K$18*$K$23))","v":1002.9607311577539}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7-0.05","v":30.15},{"$f":"(R8*33.86389)*EXP(-$K$17/($K$18*$K$23))","v":1001.3002001459033}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R8-0.05","v":30.099999999999998},999.63966913405272]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30.049999999999997,997.97913812220213]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.999999999999996,996.31860711035142]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.949999999999996,994.65807609850083]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.899999999999995,{"$f":"(R13*33.86389)*EXP(-$K$17/($K$18*$K$23))","v":992.99754508665023}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.849999999999994,991.33701407479964]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.799999999999994,989.67648306294905]
[null,"Sea level referenced barometric pressure",null,null,null,null,null,30.08,"in hg",null,{"$f":"H16*33.86389","v":1018.6258111999999},"mb",null,null,null,null,null,29.749999999999993,988.01595205109845]
[null,"Altitude",null,null,null,null,null,561,"ft",null,{"$f":"H17*12*0.0254","v":170.99279999999999},"m ",null,null,null,null,null,29.699999999999992,986.35542103924786]
[null,"Temperature (outdoor average air column)",null,null,null,null,null,80,"F ",null,{"$f":"CONVERT(H18,\"F\",\"C\")+273.15","v":299.81666666666666},"K",null,null,null,null,null,29.649999999999991,984.69489002739726]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.599999999999991,983.03435901554667]
[null,"Molar gas constant",null,null,null,null,null,null,null,null,8.3140000000000001,"J/mole/K",null,null,null,null,null,29.54999999999999,981.37382800369608]
[null,"Molecular weight of air",null,null,null,null,null,null,null,null,28.956499999999998,"g/mole",null,null,null,null,null,29.499999999999989,979.71329699184548]
[null,"Gravity",null,null,null,null,null,null,null,null,9.8066499999999994,"m/s²",null,null,null,null,null,29.449999999999989,978.05276597999489]
[null,"Constant",null,null,null,null,null,null,null,null,{"$f":"(1000*K20)/(K21*K22)","v":29.278126136440854},"m/K",null,null,null,null,null,29.399999999999988,976.39223496814418]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.349999999999987,974.73170395629359]
[null,"Local barometric pressure (aka station pressure)",null,null,null,null,null,null,null,null,{"$f":"K16*EXP(-K17/(K18*K23))","v":998.97545672931255},"mb",null,null,null,null,null,29.299999999999986,973.07117294444299]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.249999999999986,971.4106419325924]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.199999999999985,969.7501109207418]
[null,"Sea level psi",null,null,null,null,null,null,null,null,{"$f":"K16*0.0145037738","v":14.773918352486305},"psi",null,null,null,null,null,29.149999999999984,968.0895799088911]
[null,"Local psi",null,null,null,null,null,null,null,null,{"$f":"K25*0.0145037738","v":14.488914056153638},"psi",null,null,null,null,null,29.099999999999984,966.4290488970405]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.049999999999983,964.76851788518991]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.999999999999982,963.10798687333931]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H17","v":561},"ft. above sea lev."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H18","v":80},"degrees F"]